MSAccess query design to Search and Replace "#" (pound sign)
I have a JD Edwards table where an upload caused extra data to be added to two (2) description fields. I need to search for 'MSA#350298' on the description fields and replace with '' (nothing). I can search for the pound sign by using brackets. *[#]* but I cannot search for the entire string.
My plan is to use the search and replace feature in Microsoft Access. Is there a better process?