SELECT Records based on octal or decimal value at the end of a string
Posted on 2014-02-25
I need to select records from a table if they have a certain decimal value at the end of the string. After an import we get many records that contain decimal value 13 as the final character. I determined that based on doing a dump in PL/SQL.
select '('||website||')', dump(website)
I get the following:
(sunshinecavaliers.com ), Typ=1 Len=22:115,117,110,115,104,105,110,101,99,97,118,97,108,105,101,114,115,46,99,111,109,13
Now, that I know my problem records contain a decimal value of '13' I want to search my entire DB to find all records that contain the '13' at the end of the website field.