How do you strip a single quote out of a string using SSTRIP? 

I am trying to strip apostrophes (single quotes) out of a string and
cannot get a syntax for the SSTRIP to work.

 SET VAR vCustSrch = (SSTRIP(.vCustSrch, ''')

THe above treates the two leading quotes as the quote pair and the third
quote as the first of two quotes. 

I have tried variations with these manipulations 

SET VAR vQuote TEXT = ((CVAL('QUOTE'))  

SET VAR vApos TEXT = .vQuote +.vQuote + .vQuote 

SET VAR vCustSrch = (SSTRIP(.vCustSrch, .vApos) 

set var vSS TEXT  = (CHAR(39))+(CHAR(39))+(CHAR(39))  

SET VAR vCustSrch = (SSTRIP(.vCustSrch, .vSS) 

SET QUOTES = ? 

SET VAR vCustSrch = (SSTRIP(.vCustSrch, ?'?) 

SET QUOTES = '

Reply via email to