CHGVAR VAR(&FIELDX) VALUE (”’VALUE IN SINGLE QUOTES”’)
Register Hereor login if you are already a member
Remember that CL is not well suited to data manipulation. It is intended for executing a series of commands to accomplish something done while limiting human interaction. Consequently, searching a field for a specific character is not something done easily in CL.
You have not indicated what you are really trying to do. Providing that may provide a better answer to resolve the issue you are facing.
SET myfield = Replace(myfield, char(39),'')