ALTER a Colmn data length

[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

 

[Dave]

Figured it out:

mySQL="ALTER TABLE TSSEmplID ALTER COLUMN [Note] TEXT(200)"