Steve, Sorry I got to the conversation late. You don't even need to screw around with the quote characters. Since time began (well, since R:Base began), you have been able to represent a single quotation mark by escaping it with a preceding quotation mark. Then, because it is a text string, you need to surround it in quotation marks. Thus, to represent a single single quote mark as a literal value, you just type four single-quote marks in a row. (To have a quoted string of two single quotes, you would double each of the two you wanted, and surround them with single quotes, for a total of six.)
UPDATE Products + SET P_Detail = + (SRPL(P_Detail, ''', '''', 1)) + WHERE P_Detail CONTAINS ''' Bill On Fri, 17 Oct 2003 10:15:53 -0500, Fogelson, Steve wrote: >UPDATE Products SET P_Detail = (SRPL(P_Detail,|'|,|'|,1)) WHERE P_Detail >CONTAINS |'|
