Post reply

Need SQL to CAST column as INTEGER

  • July 26, 2005 at 10:56 am

    #89220

    Need SQL to cast the column "ID" as an INTEGER:

    SELECT ID, Desc AS 'Domain Name'  FROM TBL_A order by 1

    thx-

     

    BT

  • July 26, 2005 at 11:02 am

    #577250

    What is the datatype of the ID column?

    Have you tried

    Select cast(ID as Integer) as ID, Desc AS 'Doman Name' from TBL_A order by 1?

     

  • July 26, 2005 at 12:03 pm

    #577266

    2 cents worth....  Don't order by ORDINAL position it may/may not come back and bite you.  Instead ORDER BY [ID], SQL will use the "derived" value for the ordering....



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply