I have a script that contains a line to insert data into the table. In one of those fields, I have a long text which insert carriage returns. When I generate the script, this wraps on several lines. And, when being run, it will generate an error. I need to adjust the script generation to take care of those carriage returns. I would assume I would have to do something like this:

'First part of the string' + MyCarriageReturnValue+ 'Second part of the string'

What is the best way to do this?