That's what LIKE operator is for

Select * From myTable Where specificpartnumber LIKE partialpartnumber + '%'

>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).