Post reply

Concatenate two numeric fields

  • October 22, 2004 at 7:41 am

    #163604

    Is it possible to concatenate two numeric integer fields? (i.e. numbers 123 and 456 resulting in 123456)

  • October 22, 2004 at 8:05 am

    #527655

    SELECT CAST(123 AS VARCHAR(100)) + CAST(456 AS VARCHAR(100))



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • October 25, 2004 at 2:14 am

    #527773

    If you want to concatnte the two columns the first you should convert it into the string either by using cast or convert functions then use regular "+" operator to concaenatet the strings.

     

    Yuvraj

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

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