try select SUBSTR(REPLACE( 'A970 3733312229',' ','0'),-13,9) from dual; select SUBSTR(REPLACE( 'A970 3733312229',' ','0'),-13,9) from dual;
On Wed, Aug 22, 2012 at 1:51 PM, imalukegal <[email protected]> wrote: > > On Wednesday, August 22, 2012 3:30:29 PM UTC-5, Mike M wrote: > >> What value should be returned for >> A970b3733312229 700373331 >> A970bb3733312229 000373331 >> A970bbb3733312229 000373331 (this is invalid because my field can only >> be 16 chars max) >> > The result always has to be 9 characters long, padded with zeroes on the > left if needed. I have to work from right to left starting with position > 11. The field can only be 16 characters long. I cannot use postions 12-16. > > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
