REPLACE (A2K)

Topic

New Reply

I have:

Exp1:REPLACE([tPhysician],",","")

in a query to REPLACE commas with nothing. However, when I attempt to run the query I get:

Undefined funtion REPLACE in expression

What have I done wrong now? Anyone have any idea.

Reply | Quote

Replies

The only thing you’ve done wrong, it not upgrade to O2K3
I gotten bit by the same thing.

See link in this post post 646,654

Reply | Quote

Didn’t realize that….your help is much appreciated.

Reply | Quote

You can define a custom function in a standard module:

Public Function MyReplace(Expr, What As String, Replace As String)
If IsNull(Expr) Then
MyReplace = Null
Else
MyReplace = Replace(Expr, What, Replace)
End If
End Function

Use like this:

Exp1: MyReplace([tPhysician],",","")

Reply | Quote