Valid LIKE criteria – But two may cause problems
Illustration showing three Valid LIKE criteria. The one with a trailing wildcard will word well. The two with leading wildcards can be expected to cause problems, especially with long tables. They represent SQL Smells.