INSERT INTO YourTableName (BackOrdered) VALUES +
('n')
On 15 Sep 2003 at 11:08, David Torre wrote:
> Hello there,
>
> I have a 1 character text field called backordered that I want to default
> to "n." I went into rbd and set the default value to "n," and that took
> care of all the existing fields. However, whenever I insert rows,
> backordered is set to NULL and this is causing some problems with a project
> where backordered<>'y'. Is there a rule or something I can set to make
> sure that backordered is never set to a NULL value, that instead of NULL,
> it is set to n?
>
> -David
>
>
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
