varchar to text

alter datatype
varchar to text
LVL 1
rgb192Asked:
Who is Participating?
 
Bhavesh ShahConnect With a Mentor Lead AnalysistCommented:
alter table <<tableName>>
alter column <<ColumnName>> varchar(max)
0
 
Patrick MatthewsCommented:
If you are using SQL 2005, why would you want to do that?  You are better off using varchar(max) than text...
0
 
cyberkiwiCommented:
create table testtbl (vc varchar(1000))
GO
alter table testtbl alter column vc text
GO
0
 
rgb192Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.