How do you tell the script to set the default value for a boolean field to
false?

[RPIFlag] bit NOT NULL DEFAULT false, (doesn't work)

There are no 'true' and 'false' values for boolean datatype in SQL Server.
Instead we have 1 and 0, where 1 means true and 0 means false. So, your
statement should look something like below:

[RPIFlag] bit NOT NULL DEFAULT (0)
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/



"Ghost Dog" <caspar (AT) friendly (DOT) com> wrote

Thanks, that works

"Narayana Vyas Kondreddi" <answer_me (AT) hotmail (DOT) com> wrote