>Is there any way to prevent NULL values in a local view? I need the character fields to have empty strings if they are empty.
>
>Thanks
>Elyse
Elyse,

Uncheck the Allow Nulls for the table fields. If you allow nulls in the table you are going to get them in the view.