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. Kevin