Can you help me?
I need to pull a part number (GPN) based on the match from the other (SPN) part number in a table. My problem is the SPN is cut off and could match a grouping of an GPN. I need to Pull all GPNs based on the SPN. Ex below:
SPN GPN
GRM39-024X5R105K = GRM185R61A105KE36D
GRM185R61A105KE26D
GRM185R61C105KE44D
GRM185R60J105KE26D
GRM185R60J105KE26D
I'm linking an SPN table to an GPN Cross ref table that has the full SPN and GPN part numbers. I know I can use (Like SPN*) criteria, but I have a large amount of records. About 56,000 records total
Thanks
Chris
I need to pull a part number (GPN) based on the match from the other (SPN) part number in a table. My problem is the SPN is cut off and could match a grouping of an GPN. I need to Pull all GPNs based on the SPN. Ex below:
SPN GPN
GRM39-024X5R105K = GRM185R61A105KE36D
GRM185R61A105KE26D
GRM185R61C105KE44D
GRM185R60J105KE26D
GRM185R60J105KE26D
I'm linking an SPN table to an GPN Cross ref table that has the full SPN and GPN part numbers. I know I can use (Like SPN*) criteria, but I have a large amount of records. About 56,000 records total
Thanks
Chris
