I have a table with a full text index on it and I am looking for rows that contain a string like "p.G213*" but SQL server is treating the star like a wildcard, when I am trying to search for the EXACT string "p.G213*".

Is there any way to escape the star character in contains(...) ?

1 Answer 1


According to the Search for a word with a prefix (Prefix Term) doc, you should achieve it by not using the double quotation marks:

All text that matches the text specified before the asterisk (*) is returned. If the text and asterisk are not delimited by double quotation marks, as in CONTAINS (DESCRIPTION, 'top*'), full-text search does not consider the asterisk to be a wildcard..

Therefore, just change "p.G213*" for 'p.G213*'.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.