SQL Mobile 2005 Resize Column

I am trying to resize a COLUMN. Can I do this with the ALTER TABLE MODIFY command? I am getting the following error message when I try the "alter table [admin] modify [runFileTypes] NVARCHAR(250)" command.

" [ 1,21,modify ]"



command = ssceconn.CreateCommand()

command.CommandText = "alter table [admin] modify [runFileTypes] NVARCHAR(250)"

command.ExecuteNonQuery()





The only other option I can think of is to rename the old field, add a new field, copy the value of the old field to the new field, and delete the old field. I have some of the code below, but I am not sure how to copy the contents of the old field to the new field.



command = ssceconn.CreateCommand()

command.CommandText = "ALTER TABLE myTable RENAME COLUMN [oldField] TO [newField]"

command.ExecuteNonQuery()



command.CommandText = "ALTER TABLE myTable ADD COLUMN [oldField] varchar(500)"

command.ExecuteNonQuery()



command.CommandText = "ALTER TABLE myTable DROP [newField]"

command.ExecuteNonQuery()