Your technology certification is waiting. Enroll in Cloud Class ®
WHERE nMemo LIKE '%' + @Text
Open in new window
WHERE nMemo LIKE @Text + '%'
WHERE nMemo LIKE '%' + @Text + '%'
Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
WHERE CONTAINS(nMemo, '"*' + @Text + '"')
WHERE CONTAINS(nMemo, '"' + @Text + '*"')
WHERE CONTAINS(nMemo, '"*' + @Text + '*"')
Specifies a match of words or phrases beginning with the specified text. Enclose a prefix term in double quotation marks ("") and add an asterisk (*) before the ending quotation mark, so that all text starting with the simple term specified before the asterisk is matched. The clause should be specified this way: CONTAINS (column, '"text*"'). The asterisk matches zero, one, or more characters (of the root word or words in the word or phrase). If the text and asterisk are not delimited by double quotation marks, so the predicate reads CONTAINS (column, 'text*'), full-text search considers the asterisk as a character and searches for exact matches to text*. The full-text engine will not find words with the asterisk (*) character because word breakers typically ignore such characters.
When <prefix_term> is a phrase, each word contained in the phrase is considered to be a separate prefix. Therefore, a query specifying a prefix term of "local wine*" matches any rows with the text of "local winery", "locally wined and dined", and so on.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.