On Wed, Jan 22, 2003 at 14:25:28 +0800,
ryanne cruz <ryanne(dot)cruz(at)up(dot)edu(dot)ph> 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.