Modifying a field datatype size

[cpuphantom]

I need help finding the correct sql statement to increase the size of a varchar field in my database. I underestimated the size I would need.

I have tried this:
"alter table tbWeeklyReport modify (q1 varchar(1500), q2 varchar(1500))"

But I get an error near the "(" before "q1"

Is it possible to increase the size of a varchar field? I'd hate to have to delete all this info and start over.

Thanks in advance.

 

[osjohnm]

Hi

Try this instead:

ALTER TABLE tbWeeklyReport
ALTER COLUMN q1 varchar(1500)
GO
ALTER TABLE tbWeeklyReport
ALTER COLUMN q2 varchar(1500)
GO

You can only change one column at a time when using the alter table statement.

Hope this helps

John