I need a SQL Select statement that will be a partial match on another column. I need to match the middle part of another column. For example:
ItemID= 10 digits long 1234567890
EAN11 = 14 digits long. 00012345678904
I need to match ItemID "1234567890" to EAN11 column starting at the 4th position.
WHERE NOT EXISTS
FROM SAPMATUPC WHERE STEPUPC.ItemID = LEFT(SAPMATUPC.EAN11 ,10) )