Where I am using this is in a PartNumber search

So say I pass in part of a PartNumber

Here is an Example

Using LIKE

SELECT * FROM MyTable

Where LTRIM(RTRIM(PartNumber)) LIKE '%' + LTRIM(RTRIM(@PassedPartNumber)) 

---

Using PATINDEX

This returns the recordset faster then the above select

SELECT * FROM MyTable

Where PATINDEX('%'+LTRIM(RTRIM(@PassedPartNumber))+'%' , PartNumber)  > 0

---

Will