Shulou(Shulou.com)05/31 Report--

This article mainly introduces SqlServer2016 fuzzy matching methods, the article is very detailed, has a certain reference value, interested friends must read!

These are as follows:

Database is Sqlserver 2016 version

Now the business requirements are: to query the enterprise name for the following several, XXX, XXXX and so on:

First way: like '%XXX%' OR like '%XXXX%'

select cName from tAccountAuditing whereNamelike '% Testmoa000154%'ORcNamelike'% TestGroupShanghaiBusiness %'and activeAuditingCodeFromJdjr = 1

Second way: PATINDEX ('% XXX %', cName) > 0

select cName from tAccountAuditing where(PATINDEX ('% TEST MOA000154%', cName) > 0ORPATINDEX ('% TEST GROUP SHANGHAI BUSINESS %', cName) > 0) and activeAuditingCodeFromJdjr = 1

The third way: CHATINDEX ('XXX ',cName) > 0 Do not use percent sign here

select cName from tAccountAuditing where(CHARINDEX ('Test moa 000154', cName) > 0ORCHARINDEX ('Test Group Shanghai Business', cName) > 0) and activeAuditingCodeFromJdjr = 1 The above is "What are the ways of fuzzy matching in SqlServer2016" All the contents of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.