concatenate columns

[pang]

Hi ,
i have a table in SQL SErver which contains 3 colomns, in each one there is varchar code, i need to concatanate theses columns into one column without a separetor ,i don't know what's is the way , can anyone help me, thanks in advance.

[mrhappiness]

Assuming you're talking about mysql: http://dev.mysql.com/doc/mysql/en/string-functions.html

hth

[pang]

thanks for reply
I saw your page but i need to concatenate 3 columns in onecolumns this don't work

mysql> SELECT CONCAT('My', 'S', 'QL');
-> 'MySQL'

[mrhappiness]

but you got the concatenation out of the trhee values you specified 😕