1
Hi,
Use always single quote '%' in sql not double quote "%" dear.
0
Hi Mohit,
Please try the below update query and let me know if it workd for you or not
- set @sqltext= 'Select HR.HotelID AS SearchID from HotelRegistration AS HR
- LEFT OUTER JOIN Category cat on cat.CategoryID=hr.CategoryID
- WHERE HR.IsDeleted <> 1 AND HR.HotelName LIKE ''%'+@SearchText+'%''
- OR HR.[Address] LIKE ''%'+@SearchText+'%''
- OR cat.CategoryName LIKE ''%'+@SearchText+'%'''
-
- exec (@sqltext)
0
but i am using this query in dynamic storedprocedure like this
'Select HR.HotelID AS SearchID from HotelRegistration AS HR
LEFT OUTER JOIN Category cat on cat.CategoryID=hr.CategoryID
WHERE HR.IsDeleted <> 1 AND HR.HotelName LIKE ''%''+@SearchText+''%''
OR HR.[Address] LIKE ''%''+@SearchText+''%''
OR cat.CategoryName LIKE ''%''+@SearchText+''%''
0
Hi,
We can write the query as following :
- SELECT * FROM Employee emp
- LEFT OUTER JOIN City city ON city.CityID = emp.CityID
- WHERE city.CityName LIKE '%Pune%'
Regards,
Mukesh
0
Hi,
your query like operator come before field name. but it comes after field name.
Remove like operator before c.CityName and use it after field name.
exp: //use below Correct Query
select * from employee e
LEFT OUTER JOIN City c On c.CityID-e.CityID
Where c.CityName LIke '%Pune%'
Regards,
Amit