Thread: escape char
03-17-04, 04:30 #1Registered User
- Join Date
- Nov 2003
Unanswered: escape char
Hi, I want to insert a carriage return in one field, and I don't know how to perform this.
insert into test1 values('line1' || char(13) || 'line2'); insert into test1 values('line1\r\nline2'); insert into test1 values('line1#10#13line2');
How do you insert escape chars in your queries ?
thanks in advance