TEXT data Type in Sql 2000

[Surr_79]

Is there Any DataType available in Sql Server 2000 like MEMO datatype in Access?

I have an idea to go for TEXT. But It shows 16 as a Length in Design Mode. Does it mean that i can only accomodate 16 characters or what ?


Pls help me...

Suresh ......

[Davey]

In a TEXT column you can store a lot more than 16-bytes. HAve a look at the following resource for a list of SQL Server types and their allowable sizes.

http://www.databasejournal.com/features/mssql/article.phpr/2212141

[Surr_79]

Thx Davey ,

Nice link

Suresh ......