SQL & PL/SQL

Hello,

I'm trying to update a column in a table using the following code:

UPDATE pweb.pweb_tos
   SET tos_code = TRIM(tos_code);

For some reason it is not working. When I select the column using the TRIM function it does trim the white space, but the update is not working.

By the way - I did do a dump(tos_code) of the column and verified that it is in fact white space at the end.

Any help would be appreciated.....

Thanks!
Christine