Is there an SQL equivalent to the memo field in Access. If not any suggestions?
Thanks, How much data can this hold?
Take a look at the help in the SQL Server Enterprise manager.<BR>Search for nText and you'll get several items that talk about advantages, disadvantages, and limitations that my apply.
nText is used if you need UNICODE. If you don't, then stick with just 'text' and you can hold even more! Same with varchar. varchar can go to 8000 chars while nvarchar can only go to 4000