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?
