Select * from CityTable where CountryId="somevalue" and CityName LIKE '%andhra%'
Select * from CityTable where CountryId="somevalue" and CityName LIKE '% here I want to use a query(select cityname from Allcity where CityID='1')%'.
SELECT * FROM CityTable WHERE CountryId="IND" AND CityName LIKE '%'+(SELECT CityName FROM Allcity WHERE CityID='1')+'%'
Select * from CityTable where CountryId="somevalue" and CityName like '%'+ (select cityname from Allcity where CityID='1')+ '%'
Select * from CityTable where CountryId="somevalue" and CityName LIKE '%' + (select max(cityname) from Allcity where CityID='1') + '%'
max()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)