there's a concat(string1, string2) function
and also a concat_ws(',', string1, string2) newstring
--concat with separator comma alias "newstring"
http://www.mysql.com/doc/S/t/String_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 value to a variable
> 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
> verity collection
>
>
> ================================
> Nick Batt - CTO
> Sonic State Ltd.
> http://www.sonicstate.com
> [EMAIL PROTECTED]
> tel:+44 (0)1225 442546
> ================================
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
