Multi-field fuzzy query SQL like % optimization and Difference

Multi-field fuzzy query SQL like % optimization and Difference

Http://anforen.5d6d.com/

Select *

From [klims]. [DBO]. [task]

Where clientcompany like '% A %' or [address] Like '% A %'

Select *

From [klims]. [DBO]. [task]

Where clientcompany + [address] Like '% A %'

However, if one of the fields is null, data cannot be found in the second type.

Http://four-corner.appspot.com/

 

When a field is null, all the joined fields are null. You can use the second method to replace the null field '';

Select *

From [klims]. [DBO]. [task]

Where isnull (clientcompany, '') + isnull ([address],'') like '% A %'

 

This can be executed normally and efficiently.