REPLACE function in Access query ?

[Jcwy]

Dear All,
I got problem to use the REPLACE function in microsoft access query, do you
all know any other similar function that I can use ?

Thanks.

regard,
Jcwy

 

[Jcwy]

For example,
replace ("aabbcc", "a", "1") result to 11bbcc

 

[John Vinson]

Dear All,
I got problem to use the REPLACE function in microsoft access query, do you
all know any other similar function that I can use ?

What version of Access are you running? I ask because A97 (and
before), A2000 and AccessXP all handle Replace *differently*.

I'll guess you're using A2000 - it has a Replace function (unlike A97)
but oddly enough it cannot be called from a Query. The getaround is to
write a dumb little wrapper:

Public Function QReplace(strString as String, strOld as String, strNew
as String) As String
QReplace = Replace(strString, strOld, strNew)
End Function

and use QReplace in your query.