[GENERAL] Join field values

[veejar]

Hello!

I have such field in my table:

field1
-------
1
2
3
4
5


I want to get such result from select:
'1,2,3,4,5' - join all values in field1 with ','
// result must be varchar.

Help to write SELECT-query for this task.