September 16th, 2003, 03:37 PM
I am trying to delete some unreadable characters from one of the database fields called "state".
I have used the rtrim command as rtrim(state) but it does not work. But when I manually go to each record I see that there is a space right after the state.
e.g. 'NJ' actually is 'NJ '
same is the case with some other fields in the database and rtrim does not work with them.
Any one got a clue??
September 17th, 2003, 02:43 AM
how exactly are you doing this? try this query : "UPDATE [your_table] SET state = RTRIM(state)"
that should do it.