ANy ideas on how to insert a carriage return into a varchar using a script?

e.g.

insert into table (string_col) values ('abc' || #13 || 'def');

e.g. in Delphi Str := Str1 + #13 + Str2;

Thanks