Hi Fahim, Could you please explain better what you mean exactly? I think the question is not very clear. Thanks
Claudio On Jun 11, 2011 12:36 AM, "Fahim Mohammad" <fahim...@gmail.com> wrote: > Hi > > select * from tablename where fieldname in ('aaa','bbb','ccc','ddd'); > > return only the successful hit. > > How can I know how many out of four ('aaa','bbb','ccc','ddd') resulted in a > miss OR which values do not return any tuple. > > Thanks > > Fahim