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