[SQL] Full-text search CONTAINSTABLE
- by Alexander Vanwynsberghe
Hello,
I have a question regarding a CONTAINSTABLE function. I would like to find everything that ENDS WITH the search string.
I can use the * to find everything that starts with the searchvalue, but I want an equivalent for the % sign in the SQL LIKE function.
What I want: find everything that ends with 123, so as searchvalue, I could use…