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 from table where last character in string is numeric

766420May 14 2010 — edited May 14 2010
Hello,
I have a table STREETS with a field called ADDRESS. I would like to select all records from streets where the last character in Address is a number.
Select ADDRESS from STREETS where regexp_like(substr(address, ?,?,), '[0-9]');
--? means that I don't know what to put in here!

I'm not sure if substr is the best approach for this, since i only want the last character and the records are of varying lengths.

Thanks!
This post has been answered by Frank Kulash 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
3 comments
2,501 views