The following query returns 0 for sCode instead of a string like "XXX:XXXXXX".
I am modifying an existing app from SQL Server 7 so that it can also run
with a MySQL backend....
The existing query in SQL Server 7 works fine
SELECT sDAMIONCode, (sORI + ':' + sDamionCode) as sCode FROM tblORI
Any hints would be appreciated.
MySql uses '+' only for numeric addition. For string concatenation, try the CONCAT function.
Your values are being converted to integers, and become 0, for the expression you were using.
Bruce
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
