hi list.
if there's anyone here who's familiar with teh rtrim function, please i need
help.
i have a table that has a column in it that has data in this format:
California, USA
Nevada, USA
.
.
.
when i use rtrim to erase the ", USA" part, it only sometimes work. a sample
result would be:
California
Nevad
my query statement is:
update table set name=rtrim(name,', USA');
why is it that it only works sometimes?