Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 want varchar fields size more than 8000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-18 : 09:19:45
kalpak writes "I want the a column which is varchar but i want it size must be more than 8000 and it must be around 20000 will it possible ?if yes than how ??"

nr
SQLTeam MVY

12543 Posts

Posted - 2001-12-18 : 09:52:35
No.
You will need multiple fields or a text.
You could hold the first 8000 chars in a varchar and use the text field if it is larger then depending on the data you might be able to use character operations on most records.

==========================================
Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -