hi guys,
i have a list of names with came with some random characters in a bracket, which is not fixed numbers of characters, it could range from 4 to 10. etc
Name
James bond (MY0111)
Bonnie James (Taman Cheers)
i am trying to make a update query that removes the characters including...