Hello,

ist there an alternative for this?

> In a script you can use this:
>
> insert into foo (test) values ('Hello
> world');

The reason is: I'm generating my "insert into"-lines in Excel. Once one of the cells contains a linebreak, the copied value from Excel has an " at the beginning and at the end, which breaks the SQL script.

I seem not to be able to find a solution in / for Excel, so I thought that Firebird might have a solution for such a case.

I would try to replace the linebreaks in Excel with required chars etc., so that the script still works and also the linebreaks don't get lost and get inserted correctly.

--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov" <SD@...> wrote:
>
> On 24 Mar 2004 at 9:10, diwic2 wrote:
>
> >How do I insert linebreaks into a string with ISQL?
> >
> >I'm looking for something like this:
> >
> >insert into foo (test) values ("Hello"+#13#10+"world")
>
> In a script you can use this:
>
> insert into foo (test) values ('Hello
> world');
>
> SY, Dimitry Sibiryakov.
>