It works :-)
Thanks a lot.
Uzytkownik <thojens_at_gmx.de> napisal w wiadomosci
news:1107345837.148861.113250_at_z14g2000cwz.googlegroups.com...
> jazzz_ wrote:
>> Hi,
>> I have to update values in one column (character).
>> Now all values are like: "1234", "2345", "3456", and etc.
>> They have to be "1234A", "2345A", "3456A" etc.
>> Is there ane method to do this with sql+ ?
>
> The concatenation operator in SQL is '||'. So:
> UPDATE x SET column = column || 'A';
>
> Thorsten
>
Received on Thu Feb 03 2005 - 02:46:29 CST
