[SQL] UPDATE with concatenate

[Laurent Patureau]

Hy,

I try to update a table:col with take the valueof this col and concatenate 
it with $val.
I don't want to select all value of table:col and addition $val at each one

I try :

UPDATE table SET col .= '$val'

But it doesn't work, any suggestion ?


pat


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])