Text fields are only limited by the OS's maximum file size. Gigs and gigs.
You're thinking of the varchar limit. There's not way to go past the limit on varchars, but you can always use text instead. I hope that made sense. --Ben DRE wrote: > Hi, > I've noted that the text fields in sql 2000 only go out to 8000 chars. > Is there a means to increase this? > > A good resource for these questions would be great as well. > > Thanks. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184013 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

