Use * as query criteria, not as a wildcard character

[kpal29]

I have a set of data where certain fields contain an *. I want to find and remove these asterisks.

I have the same problem with the # sign. Since these characters already have a meaning in Access, they are not being treated as simple strings.

How do I force Access to treat them as text?

Thanks

 

[Crowley16]

well, if you just want to replace them, then use a replace statement in an update sql

update table
set fieldname = replace(fieldname, "char", "repChar")

do backup before doing this...

--------------------
Procrastinate Now!

 

[cmmrfrds]

Special characters can normally be treated as literals by using square brackets. For example

yourfield Like "*[*]*"
or
yourfield Like "*[#]*

 

[kpal29]

Thanks, the brackets did it.