This is just a very short post regarding the use of wildcards in a WHERE Clause
It is possible that the first WHERE clause below can use an Index seek
Where LastName like ‘[a-z]%ent’ can use an index
This second statement will not be able to use a seek and will result in a scan
WHERE LastName like ‘%ent’
0 Comments