> I want to ensure there is a value, but IBO does not
> allow the Insert to make use of the default on the database.
>
> Is there anyway around this problem???

The simplest (and most client/server friendly) is to attach before
insert and before update triggers to the table. Test if null and set
to ''.

This is better than applying at the client, otherwise you will find
yourself caught out one day when someone inserts some data from
another client or utility that does not apply the same rules.

I do this for all my string fields - since I find handling nulls a
real PITA.

HTH

Geoff Worboys
Telesis Computing