Re: update character column

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 Wed Feb 02 2005 - 06:03:57 CST