Search results

Thank you for your advise, sir. I shall change that field into something else. you've been great help. ;)

Thank you for the quick reply, sorry i noted the wrong results. this is the sql code: UPDATE raw SET raw.name = Left([Name],InStr([Name],"(")-2); Your code appear to work perfectly fine, only if i added the criteria of "*(*)" because some of the data need not changing. or it would wipe out...

Hi guys, thank you for the quick reply. So i tried both code and both gave me error. For Steve's code, it didnt change anything. for namliam's code, it wipes out the entire field. but at times it works, though it left a space right behind the name but i think that can be solve quite easily...

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...