Thanks! works a treat!
n
At 09:09 26/10/2001 -0400, Kalok Lo wrote:
>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
================================
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
