>I need to convert some fields from Character type to Character (binary) using Alter Table so they can hold passwords. I can't seem to find any reference to this code anywhere. I can do it with Modify Table but I need to send out an update that does it on the run.
>
>Anyone know how to do this? Following code returns Syntax Error.
>
>Thanks
>

alter table stuff ;
>alter column c1 character binary(30) ;
>alter column c2 character binary(30)

alter table stuff alter column c1 C(30) NOCPTRANS

Regards,
Pieter