I need to replace a goofy character CHR(141) with a space in a memo field. Does anyone know how this is done? It looks like a REPLACE command with the ADDITIVE keyword would do it, but I can't get it to compile. (You can't use the STUFF() function in a memo field.)
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Replace / Additive
- Thread starter ShareBear
- Start date