Crystal 8.0 SQL Expression help

Yahoo Archive
1
I have the following expression that works poperly returning the first 3
characters in the salesreplist memo field

{fn SUBSTRING( "PUB"."OrderHed"."SalesRepList",1,3)}

When I try to use

(fn REPLACE( "PUB"."OrderHed"."SalesRepList","~","")}

I get a Merrant error 7520 followed by an "error compiling SQL expression".
What am I doing wrong? Any help would be appreciated.

Dan Shallbetter
States Electric Mfg.