Why is it when I run this SQL String against a MS SQL db it works fine:

But when I run it against a MySQL DB I get a zero value for the "USERLNAM + ' ' + USERFNAM + ' ' + Title".

if I run the following SQL String against the MySQL DB it works fine:


How do I write this SQL String so that is works with both DB?

I am using ADO and VB6 to connect to both DB.

think I found the answer to my question the CONCAT Function

But I don't have a MS SQL DB available to check and see if this function willl work with it. Can anyone advise?

you cannot use the same sql statement on both of those database systems

they are just flat out not syntax compatible for concatenation

Thanks Rudy!