totally agree with you Chris.. but i think here OR operator will be more reliable because with correct data OR and AND will return same records ..What do you think ?

Gosh, I wouldn't rely on that nuance especially for the sake of clarity. I would absolutely use AND in this case just to avoid any confusion in the heat of an emergency fix, should it ever occur. A newbie wouldn't understand the ORs are an implied AND simply because of the IDs involved.

--Jeff Moden"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Jeff Moden (10/8/2013) Gosh, I wouldn't rely on that nuance especially for the sake of clarity.

Thanks Jeff for keeping close eye on all the replies , it actually helps me a lot .. you know your quoted word "GOSH" made me to read your and mine first reply 6 times to see what mistake i made and then finally realised that i overlooked the below OP's text.

I need data based on 1. CountryId2. CountryId and StateId,3. CountryId, StateId and CityId

-------Bhuvnesh----------I work only to learn Sql Server...though my company pays me for getting their stuff done