CODEWITHSUNDEEP
ms-accesschar
Lord OfTheRing
Lord OfTheRing

Reputation: 1309

Substitute CHAR(150) in MS Access

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))," ","")

Upvotes: 2

Views: 67

Answers (1)

June7
June7

Reputation: 21379

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

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

Upvotes: 1

Related Questions