Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    54

    Unanswered: concatenation of numeric text

    How do I concatenate two numeric text values to return a string?

    For examples Concatenate '03' and '2008' to '032008'?

    Both values are char data type

    thanks!

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    declare @w char(1)
    declare @t char(1)
    set @w='1'
    set @t='2'
    select @w + @t

    yields '12', so there you go.

Posting Permissions

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