I have a field that holds a part number pattern, not the specific part number:

Example: 85786

I need a sql statement that will be given a specific part number and I need to find record matches to the partial part number.

Example:

Select * From myTable Where partialpartnumber(85786) is a part of specificpartnumber(857869-401A).