Hi: How can I change the datatype (online)from "text" to "number"? Why ALTER works fine with ADD and DROP, but doesn&#039;t work with MODIFY? I use non-SQL server.<BR><BR>1. alter TABLE student ADD rank text; [works fine]<BR>2. alter TABLE student DROP rank text; [works fine]<BR>3. alter TABLE student MODIFY rank number; [Syntax Error in ALTER TABLE statement]<BR><BR>Thanks for any help.