Substitute CHAR(150) in MS Access

Question

I have MS Access Table fields which has values CHAR(150) - and I like to replace it with CHAR(45) -. HOw can I do in MS Access query ?

I tried below in Query but SUBSTITUTE does not exist. It works great in Excel Replace(SUBSTITUTE("Value1",CHAR(150),CHAR(45))," ","")

Answer 1

Replace() does substitution. Chr() is Access function.

Replace([fieldname], Chr(150), Chr(45))