concatenate two fields

[RicardoPereira]

hi,

How do i concatenate two text fields, for example:
Field1: Ricardo
Field2: Pereira

In SQL Server i do:

Select Field1 + ' ' + Field2

and i got "Ricardo Pereira"

How do i do that in mysql ?

Thanks

Ricardo

 

[ggggus]

SELECT CONCAT(Field1,' ',Field 2)

more info here

http://dev.mysql.com/doc/mysql/en/String_functions.html

***************************************
J. Jacobs

http://www.piercedmedia.com