I am trying to run a select statement on a table acct id. My account ID's can have the following pattern which is the one I am having issues with: 2733R9087813964

How do I run a SELECT Statement on this column and extract only the numeric portion after the "R"? So the result in this scenario would be: 9087813964

Any help would be appreciated.

CodePudding user response：

try

SELECT Substr(ACC_ID, Position('R' IN ACC_ID)  1 ) 
FROM ACCOUNT