Jim,

I checked Help file and I didn't see, how can I change the length of the field using ALTER TABLE. Is it possible at all? Say, I had N(4,0)) and I want to change to N(2,0)? Also it's not clear to me, how to change field type?

Could you please advise?

Thanks in advance.

>

><strong>ALTER TABLE MyTableName</strong> ;
>ALTER COLUMN PROPID I NULL ;
>ALTER COLUMN SITEID I NULL ;
>ALTER COLUMN SITEID2 I NULL ;
>ALTER COLUMN ASSRID I NULL ;
>ALTER COLUMN TRANID I NULL ;
>ALTER COLUMN MISCID I NULL ;
>ALTER COLUMN CREDID I NULL ;
>ALTER COLUMN COMPLEVL C (1) NULL ;
>ALTER COLUMN COMPLEVL DROP CHECK  ;
>ALTER COLUMN SOURCE C (1) NULL ;
>ALTER COLUMN SOURCE DROP CHECK  ;
>ALTER COLUMN PREFCODE C (1) NULL ;
>ALTER COLUMN SITESRCE C (1) NULL ;
>ALTER COLUMN CCODE C (2) NULL ;
>ALTER COLUMN TOWN C (4) NULL
>

>
>Nadya,
>
>Try adding the highlighted line at the beginning