David, Go into the database designer, and modify the column definition to set the default value to N.
Bill On Mon, 15 Sep 2003 11:08:40 -0700, David Torre wrote: >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?
