neetus

• Mar 7th, 2007

 

select employee_name from employees where substr(employee_name,-1,1)='S';

Faizal

• Mar 8th, 2007

 

Also, u can try this way:

select ename from emp where lower(substr(ename,length(ename),1))='s';

Cheers - Faizal

Raj

• Mar 22nd, 2007

 

select ename from emp where substr(ename,-1)='S';

roosu

• Sep 6th, 2007

 

Hi,
Try this:

SELECT * FROM emp WHERE ename LIKE '%S'

pradeep bhargav

• Oct 12th, 2007

 

select employee_name from employees where substr(first_name,-1)='s'

ashishkumar2403

 Profile Answers by ashishkumar2403 

• Dec 21st, 2009

 

SELECT DECODE(instr(employee_name,'s',length(employee_name)),length(ename),employee_name,null) FROM table_name ;

Will give all names ends with 's'.

goutamgeek

 Profile Answers by goutamgeek 

• Dec 22nd, 2009

 

select * from table_name where substr(first_name,length(first_name),1)='S'

emraan

 Profile Answers by emraan 

• Dec 29th, 2009

 

select * from emp where substr(ename, -1) = 'S'

Thanks & Regrads