I have Part ID's in my db that contain extension ("RTN", "SRTN") that I do not want to show up in a report. How can I remove the extensions and only show the part number?
1133500-1 RTN
1133541-10 SRTN
