ALTER a Colmn data length

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I am running an asp \ sql and trying to modify a text column

mySQL="ALTER TABLE TSSEmplID MODIFY (Note Text(200))"

In place of TEXT, I have tried VARCHAR with the same results.

I am getting a syntax error : Syntax error in ALTER TABLE statement

I am not sure this can be done.

Dave
 
Back
Top