From: hugo@perFact.REMOVETHIS.info.INVALID   
      
   On Thu, 7 Oct 2010 17:33:19 -0400, Phil Hunt wrote:   
      
   >Can someone tell me how much data can I store in a colume defined as   
   >Varchar(max). I am using SQL 2008.   
   >   
   >Thanks   
   >   
      
   Hi Phil,   
      
   The maximum storage size for all ...(max) data type is 2^31-1 bytes. And   
   since varchar uses 1 byte for each character, that works out to 2^31-1   
   characters. Or, in decimal form, 2,147,483,647 characters.   
      
   --   
   Hugo Kornelis, SQL Server MVP   
   My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)