On Wed, Jan 22, 2003 at 14:25:28 +0800, ryanne cruz <ryanne.cruz@xxxxxxxxx> wrote: > > 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 You may want to keep the country as a separate column.