Problem With Replace Function

[Kenos]

V_SQL = V_SQL & &quot;RTrim(LTrim(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((SELECT ParentName From CategoryParentLookUp WHERE Product.CategoryID =MainID),',','<\Co>'),CHR(34),'<\DQ>'),CHR(13),''),CHR(9),''),CHR(10),''))) AS MainCategory From PRODUCT

I get this Error.
Undefined function 'REPLACE' in expression

When I run this from my Access DB it works fine.


But will not work with running from web page

Question is:
Is there a work around to this?
Not using the REPLACE Function in ASP,
Because it the Record Set is large and taxes the server.

Any help would be great.

 

[newbiepg]

you forgot to end it correctly
you need to provide the &quot; at the end of the line