I think in the word “Let’s” the single code(‘) is recognized as a special charactor. Thats why it is returning error. So when passing the input to the stored procedure just add one more singlecode(‘) like
“Let”s” that is give two single codes between t and s and try. it will work.
Thanks & Regards,
Without describing what you mean by a stored proc “reading” a word, there’s no way to supply a useful answer. Reading by way of what kind of I/O method? Reading from where?
In essentially every language I’ve ever used, there are problems handling strings that can contain delimiter characters within the string. AS/400 stored procs are no different from any others in that respect.
Tell some minimal description of how you’ve tried things and we can probably help.