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??
Thanks
SaadG.HQ@keyence.com
how exactly are you doing this? try this query : "UPDATE [your_table] SET state = RTRIM(state)"