MS access - Remove brackets from a string

I need to remove [WA] from the string [WA] Clark.

How do I do this?  I figure I need to escape them or something to treat them as literal
I'm trying to update a large table.

Thanks
KS
keschusterAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
OR

Trim(Replace("[WA] Clark.","[WA]",""))

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Replace(Replace("[WA] Clark.","[",""),"]","")
Returns

WA Clark.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.