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