Maybe this?
update table set col = col || '$val';
On Thu, 7 Jun 2001, Laurent Patureau wrote:
> 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 :
>
> UP
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 broa