Hi,
I just want to insert a break line in a char(200) datafield with a simple insert/update query :
update toto set my_txt="My title.Insert a breakline here. My txt."
where ...

Thanks in advance.

Hi,
Yuo want to insert a break into the databse or in a flat file ?

With update, would can you try to arm variables with the first 199
characters, to concatenate the wished character to him and to
concatenate the rest to him of string.

With a flat file can yuo then awk for the change.

Gustavo.