PL/SQL string function 1

[malaygal]

Does Oracle has left and right string function.
I need to extract the 2nd to the last character of a string as part of my WHERE clause in a sql string similar to this :

...where left(right(ucase(name),2)l,1) = '2'

Any help will be greatly appreciated.

 

[jimirvine]

Hi
use substr

select substr('abcdef',length('abcdef')-1,1) from dual;

 

[carp]

A little simpler:

select substr('abcdef',-2,1) from dual;

 

[SantaMufasa]

Cool, Carp! The tightest, simplest code of all (WDITOT)...Please accept this

for your cleverness!

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]