I am having a Sql table like
HId HName CityId(int) NearByCityId(varchar)
1 xxxx 2 3,5,6
2 rrrrr 4 null
3 sdfd 3 5,6
Now when user passes CityId its straight forward.
But now I need to lookup in NearByCityId along with cityId.
e.g, when CityId 3 is passed then it should be searched in CityId and NearByCityId columns
where CityId = 3 or NearByCityId contains '3'
Stucked here. Your help is really appreciated.
Thanks in advance.