select * from TABLE where countryid = @country
select * from TABLE where countryid = @country OR stateID = @stateid
select * from TABLE where countryid = @country OR stateID = @stateid OR Cityid = @Cityid
Here @country ,stateID and @Cityid are parameters.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)