Retrieve Names from Table

How to retrieve names from table starting with a particular character as a first letter, using with substring, instring without using LIKE function.

rajalingeswarrao
Profile Answers by rajalingeswarrao Questions by rajalingeswarrao
Nov 16th, 2008
3
2373

Questions by rajalingeswarrao

SQL

Answer

Showing Answers 1 - 3 of 3 Answers

askmahantesh
Profile Answers by askmahantesh

Nov 26th, 2008

Consider the table EMPLOYEES with the column ENAME. Try with the following queries.

Select ename from employees
where Instr(ename,'&A') = 1
group by ename;

'A' --> your starting character.
OR

Select ename
From employees
Where Substr(ename,1,1) = '&A')
Group By ename;

'A' --> your starting character.

OR

Select Decode(Instr(ename,'&A'),1,ename)
From employees;
The above displays the nulls but try to remove the nulls.