Mens Bronze 1 Bronze Championship Adult Pairs Championship
1st column is EventTypeDescription (ETD)
2nd column is EventTypeLevel (ETL)
Most of the ETD precedes with the ETL, BUT not always, such as the "Mens BRONZE 1"
What I'm trying to do is remove the ETL that exists in the ETD field and show the ETD without the redundant ETL information.
What is the best way to do this?
Either in SQL (though the db is SQL) or in Access query or Access module / VBA?