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 = '