homerjones1941 wrote:

> I think I will implement the "Default" solution
> Would there be a problem in using Coalesce(...) in addition to setting the default values? I can't think of any, other than it may be overkill.

There would be no problem, and it is not overkill. Please note that
default is only used if column is not specified in INSERT. If you run

insert into t1 (field1, field2) values ('abc', NULL);

You would still have NULL in the field. Therefore, it might be best to
use COALESCE even if you have default set.

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================