var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MySQL - Combining Fields
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".
"SELECT USERLNAM + ' ' + USERFNAM + ' ' + Title, USRNUM "
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?
"SELECT USERLNAM, USRNUM "
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?
"SELECT CONCAT(USERLNAM, ', ', USERFNAM, ', ', Title), USRNUM "
you cannot use the same sql statement on both of those database systems
they are just flat out not syntax compatible for concatenation