>>Or specify the same default value in the view definition, and the view takes care of itself.
>
>That's a maintenance headache (as all duplication tends to be).
If you maintain your views in code, and have a routine that generates them, you can have the same routine copy extended field properties from the table to the view. Only a maintenance headache if you do everything manually. :)
Erik Moore
Clientelligence