SQL LIKE convert to SQL CONTAINS
What is the right syntax for converting a SQL Like to Contains in the following fragment statement:
WHERE ReferenceNo LIKE '%' + @SearchString+ '%'
I have converted it to:
WHERE ReferenceNo CONTAINS(VendorName, @SearchString)
VendorName is in the SELECT statement.
Thanks in advan开发者_运维技巧ce. :)
If you were just converting the WHERE statement you showed, it would be
WHERE CONTAINS(ReferenceNo, @SearchString)
精彩评论