We have a shop that has appended alpha characters to standard part codes.
We need to run a compare query between part codes in other tables and those
in this shop's table, but the alpha characters at the end of their codes
need to be removed before the codes can be compared. The codes vary in length
and some have internal alphas, but all codes properly end in a number. Do
you have a transact query for removing all the alpha characters at the end
of a string for each field in a column? We are using SQL Server 6.5.