I need to populate a field via a dynamic SQL statement. I want my field to contain 'A'. Not A .... but 'A'. How do I embed the single quotes inside the sql string? The following does not work, and errors with -104 - invalid token. Assume the below variable is 10 positions long.
Are you implying to replace the inside single quotes with double quotes? I am certain I tried this and it wouldn't work ..... as far as I recollect it wouldn't even compile. I am coding in RPG Free. I need to populate a file / field with 'A' (including the single quotes). In using a dynamic sql statement the string needs to be surrounded by single quotes. Any other thoughts would be much appreciated. Thank you kindly for your reply.