>Well, it will be
>

>FieldName LIKE '%[.]ext'
>

>This will be non-sargable, so if you can create a computed column for extension and index on it, the performance will be better.

Thanks, I have additional integer index that are part of the query. So, this short out the result to about 10 to 20 records at most. If I add a condition like this, it should be pretty much fast I guess.

What is non-sargable?