It even has a name - SARGable - able to use an index on the [S]earch [ARG]uments but still easy to get tripped up. https://www.definitions.net/definition/sarga

It even has a name - SARGable - able to use an index on the [S]earch [ARG]uments but still easy to get tripped up. https://www.definitions.net/definition/sargable https://www.definitions.net/definition/sargable https://stackoverflow.com/questions/799584/what-makes-a-sql-statement-sargable https://stackoverflow.com/questions/799584/what-makes-a-sql-...