Hi Dorin

>I use smallint as well.

Thanks Dorin

>You can create a domain that can emulate a logical column.
>

>CREATE DOMAIN LOGICAL AS SMALLINT DEFAULT 0 CHECK (VALUE IN (0,1))
>

>or
>

>CREATE DOMAIN LOGICAL AS CHAR(1) DEFAULT 'F' CHECK (VALUE IN ('T','F'))
>

This means that we can create custom datatypes or atleast custom datatype names?

>If you are using domains for columns definition, you can easily change all columns based on a certain domain in all tables.

I just go in for the defaults.

>The good news are that records are not physically changed untill they are "visited"

In what manner