A different way to concatenate.

[setowmich]

Hi, is there another way I can concatenate in MySQL other than using the Concat() function? Are there some sort of setting I can tweak where I can get MySQL to read the following:
"LastName"+', '+"FirstName"

The reason I need this is I"m trying to replace a Access DB that is talking to a third party application over ODBC. This application has a function to export data over ODBC and I'm trying to intercept it from Access.

Thank you very much

Joe

[Sxooter]

If you turn on the ansi switch you can use standard ANSI concatenation like so:

select 'abc'||'123';
abc123

[setowmich]

Thanks for the reply, I already have ANSI turned on because the person who wrote the software used " " as the idenitfiers. I can't use your method because I do not have access to the edit the 3rd party software. I'm stuck with "Last Name"+', '+"First Name". Is there another way?

Thank you

Joe