OraFAQ Forum: SQL & PL/SQL » finding the names where the 3rd letter is an A

Home » SQL & PL/SQL » SQL & PL/SQL » finding the names where the 3rd letter is an A

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

finding the names where the 3rd letter is an A [message #681]

Tue, 26 February 2002 07:06

irs
Messages: 1
Registered: February 2002

Junior Member

Hi,
How can I display the names of all employees where the 3rd letter of thier name is an A?
And another question , how to display the names of all employees who have two Ls in thier name ?
Thank you.

Report message to a moderator

Re: finding the names where the 3rd letter is an A [message #683 is a reply to message #681]

Tue, 26 February 2002 07:22

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

1. select * from emp where substr(ename,3,1)='A';
2. if u r searching for existence of "LL" then
select * from emp where instr(ename,'LL')!=0;
3.if u r searching for name having equal or more than 2-L then
select * from emp where instr(ename,'L',1,2)!=0;

Report message to a moderator

Re: finding the names where the 3rd letter is an A [message #769 is a reply to message #681]

Sun, 03 March 2002 23:17

Daman
Messages: 4
Registered: March 2002

Junior Member

Hi This is daman
your question
How can I display the names of all employees where the 3rd letter of thier name is an A?
The query given below will work
select * from emp
where ename ename like'___A%'

Report message to a moderator

Previous Topic:	urgent :regarding data transfer from one oracle server to another
Next Topic:	Updating a field in a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:53:38 CDT 2024