SQL Server - LIKE Command Not Working on host : hi everyone i have this query

    SELECT * FROM Takhfif WHERE TakhfifName LIKE '%keyword%' AND CityID=2"
this is an example i have dynamic version of this code.
However this code is working great on local but not working in host!
my local Sql Server is 2014
and the host sql server is 2012
if this code not working on sql server 2012 what code should i use for a exact search?!