>>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

Pieter,
. You just made my day. That code is not listed anywhere.
Many thanks,
John