Jeff Moden (5/25/2014)

---

Lynn Pettis (5/25/2014)

---

Realize that you lose any benefits of having an index on the TransDesc column. If you can, you may want to consider adding a persisted computed column that stores the first 20 characters of the TransDesc column (LEFT(TransDesc,20)) and build an index on that column.

+1000

But to add to Lynn's good suggestionn, an even better option would be to normalize the data instead of having more than one piece of information in a single column.