I am working on a stored procedure that requires a literal string to be input into a VARCHAR(1024) variable.
My stored procedure has no problem reading the word........... Let''s
However, if I try to read the word............Let's, I get a code violation.
Do I need to read the string as a datatype which does not care about single apostrophes?
And then convert the string into VARCHAR?
Please help as I have been searching for days to find the answer to this "tricky" proposition.
I cannot imaging that some of you out there have not run up against this while writing stored procedures for the iSeries/AS400 !!!!
I will appreciate your response.
December 27, 2007 11:04 PM
March 7, 2010 11:55 AM