>How can I specify a default value for a field that
>already exists in a table ?

>The field is called IS_DELETED and is specified as
>follows:

>IS_DELETED VARCHAR(1),

>I want it to have a default value of F (for false)

In a delphi App, you can do it in a AfterInsert event
of the table

You can also do it in a before insert / before update
trigger of the table, after checking the value of
the old value

Hope it helps

regards

Joseph


___________________________________________________________
Do You Yahoo!? -- Une adresse @... gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com