I have a 2 columns in a table that have the following type of information:
Col 1 Col 2
A4 Adminstrator A4
A5 Analyst A5
Basically this data was pushed to our database from a different source. When I display the information with Cold Fusion they want the display to look like this:
A4 - Adminstrator
So they want the A4 taken off the end of the col2, but they don't want it deleted from the database. What's do you think is the best way? I think if I find col1 in col2 and then trim the col 2 based on location. By the way not all of the codes are 2 letters. Some are 3, some are 4, some don't have any.