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

askmahantesh

 Profile Answers by askmahantesh Questions by askmahantesh

• Nov 26th, 2008

Consider the table EMPLOYEES with the column ENAME. Try with the following queries.Select ename from employeeswhere Instr(ename,'&A') = 1group by ename;'A' --> your starting cha...

Answer Question  Select Best Answer