Change size of multiple columns

[SarasotaIT]

I am looking for the proper syntax to change the size of 2 or more columns in my table in one query. Here is what I have to change the size of just ONE column:

ALTER TABLE MyTable
ALTER COLUMN [COL1] char(6);

But, what if I wanted to change the column size of COL1 and COL2 in the same query?

Thanks much in advance!
Terry

 

[BNPMike]

Just a point here, setting the size of a text field in Jet doesn't actually do very much. Jet does not allocate storage on the basis of your field size. It allocates it based on the actual size of the data (obviously up to but not exceeding the size you declare).

What I'm saying is if you're worried you might need to expand your field size, just set it at 255 bytes.