Replace hash (#) with query

[JKaranka]

Hi guys!

I have been having this problem with trying to replace hashes from a field for a little while. I know that they are wildcards for number in queries, but still, the usual brackets approach doesn't seem to help when within a replace function.

The two main failed attempts have been run an update query in which the field is updated to the following:

a) Replace([Age],Chr(35),"")
b) Replace([Age],"[#]","")

Neither one of which has replaced any hashes.

Any help would be appreciated!

[jzwp11]

Can you post the SQL text of the query you wrote? I tried the following in an example database and it worked with no problems

UPDATE Table1 SET Table1.myTextField = Replace(mytextfield,"#"," ");

[JKaranka]

Hah, you are completely right. I cannot believe I have been trying to square the circle nor I understand how I ended up trying to! Thanks!

[jzwp11]

You're welcome!