Results 1 to 2 of 2

Thread: urgent help

  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unanswered: urgent help

    I am using MSquery,and I want to convert the char result to number or integer....I tried using convert(value,data type),to_number(value)....and nothing worked.Someone please let me know which function to use.
    Thanks

  2. #2
    Join Date
    Apr 2003
    Posts
    191

    Re: urgent help

    Hi,

    in DB2 SQL, you can try the functions

    INTEGER( 'yourcharrep' ) or
    DOUBLE( 'anothernumber' )

    Also available are BIGINT, FLOAT, REAL.

    Johann

    Originally posted by rama_ttu
    I am using MSquery,and I want to convert the char result to number or integer....I tried using convert(value,data type),to_number(value)....and nothing worked.Someone please let me know which function to use.
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •