Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select records where last character in string is a letter

766420May 14 2010 — edited May 14 2010
Hello,
I have a table STREET with a field NAME where there is single letter at the end of some names that shouldn't be there. I want to select all the names that are like this. For example: "GREENE *B*", "JOHN LOT *J*".

what i would like to do with this query is populate a new field NAME2 with the correct version of the name without the last letter. Ex: "GREENE B"-> "GREENE".
Would this be an RTRIM command?

Thanks!
This post has been answered by garbuya on May 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2010
Added on May 14 2010
18 comments
4,439 views