[kapoor007]

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

[shabbir]

. should be ,

Also

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