Re: Query not returning what I expect....

2003-03-26 Thread Bruce Feist
LaBranche, Kevin wrote: The following query returns 0 for sCode instead of a string like "XXX:XX". 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

RE: Query not returning what I expect....

2003-03-26 Thread Don Read
On 26-Mar-2003 LaBranche, Kevin wrote: > > The following query returns 0 for sCode instead of a string like > "XXX:XX". > > 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 sDAMION