Multiple Lines as Value Parameter

[gbl0815]

I have to process a Text Database an copy that Data into a SQL Database (MS SQL 2000). I process this Data with Delphi.
Now, some Textfields contains CRLR and my Insert command fails. That Field is a Decription Field of my Customers Table. So that Field can contain multiple Lines.

Sample:
create table adr (description vchar(4096));
insert into adr values ('Line1'#13#10'Line2)';
-> Fail

What is the correct Syntax of the SQL Statement that can contain text values with multiple lines?

 

[fluteplr]

insert into adr values ('Line1'+char(13)+'Line2')

you don't need the char(10).

 

[gbl0815]

Thank you. It´s so simple