tring_functions.html
>Refer to the above page for more useful string functions
>
>
>- Original Message -
>From: "sonicstate" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, October 26, 2001 9:00 AM
>Subject: joining a string and a
Hi, I'm new here may as well jump right in with a question
Anyone know the equivalent of
's' + convert(varchar,id) as dkey
The result I get in MSSQL 7 is s1, s2, s3 etc
have tried 's'+id as dkey but just get 1,2,3 etc
need to concatenate the two values 's'&id inside a query to populate a
