开发者

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)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜