On 14 May 2004 at 6:37, d_dude_2003 wrote:

>I need to create a text for memo field and post it to table
>in my stored procedure.
>
>1. Do i have to declare VARCHAR(2000) variable or something like that
>to create a text?

Yes.

>2. How do i add #13 and #10 chars when adding text to this variable?

Use UDF or just put newline between apostrophes:

a = a ||'
';

>3. Will the following syntax work
>
>INSERT INTO SomeTable(MemoField) VALUES (:MyLongVarCharVar)?

Yes.

SY, Dimitry Sibiryakov.