I'm trying to replace "(any text)" in the company name field with a blank. I tried using the following but it doesn't work. Sample Data: Bridgeport Mortgage Company (San Fran) In my update query - Replace([Company Name],"(*)","") I get no changes... As an example - this seems to work... Replace([DBA],"(San Fran)","blank") I get Bridgeport Mortgage Company blank.... This is great but I need to remove any parantheses and leave the space blank. Why won't the query recognize the wildcard?