>Yes, it works if I don't have part numbers I need to lookup less than -400. But suppose I have two part numbers 851251-4 And 851251-403. If I use your suggestion the 851251-4% will return any 851251-403's.
What is a structure of the part #? What wildcards DB2 supports in the LIKE operator?
--sb--