oracle doubt

kapoor007's Avatar
Newbie Member
i m havin a doubt in writing a query to select ename,eno of those employees whose name starts with a or s
what i feel is
select ename.eno from emp where ename (like 'a%' or like's%');
plz solve my doubt
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
. should be ,

Also

ename (like 'a%' or like's%'); should be ename like 'a%' or ename like's%';