I have problem as : I use word "like" in sql to search such as
SELECT * FROM Customers WHERE address LIKE @Keyword;
if keyword is phrase word not only single word problem will occur !
For example : Keyword is "Ciputra E4" and i can not find records with address "18.03 E4 Ciputra "
How can i solve this problem ?
Give me a advice ! Thank you so much !