Custom Query with geocode and keywords

I am struggling for a solution to this. I need to return location and keyword search from a table. The fields I am searching are varchar. The problem is a custom query does not allow for wild card contains or like. I Have searched the forum and have seen others with this issue but really no solutions to my issue. I have it working separately but when I join the two to one search I get no returns without a wild card on the keywords any Ideas or help would be appreciated. Also maybe there is a better solution to this?

Community Page
Last updated: