|Subject||Re: [firebird-support] Simple Table cloning?|
> The problem is that using the EXTERNAL FILE to declare a table doesn'texternal
> allow the option of interpreting blanks as NULLs, nor does setting a
> field to NULL in an external file actually set it to NULL, and hence
> I'd like to create a (yes, temporary) table to copy the data from the
> file table, perform the necessary processing and then place the dataBecause you are using Firebird 1.5, you do not need temporary table
> into the new tables.
for this task; just use NULLIF function to convert blank to NULL
when copying data from external table to new table.