field type to hold large amt of text

<i><b>Originally posted by : Theresa (tmargel@frycomm.com)</b></i><br />I am using SQL Server 7.0 and I need to create a field that holds a large amount of text (i.e. an article). The only choice I found that was close is the varchar, which holds up to 8000 characters. Is there a better way?<br />

<i><b>Originally posted by : Luciano (luciano@asas.net)</b></i><br />hi Theresa,<br /><br />Did you try to use a memo field ??<br /><br /><br /><br />------------<br />Theresa at 8/18/2000 9:05:27 AM<br /><br />I am using SQL Server 7.0 and I need to create a field that holds a large amount of text (i.e. an article). The only choice I found that was close is the varchar, which holds up to 8000 characters. Is there a better way?<br />

<i><b>Originally posted by : </b></i><br /><br />the memo field is not an available option in SQL Server 7.0.... only in Access.<br /><br />------------<br />Luciano at 8/21/2000 10:19:09 AM<br /><br />hi Theresa,<br /><br />Did you try to use a memo field ??<br /><br /><br /><br />------------<br />Theresa at 8/18/2000 9:05:27 AM<br /><br />I am using SQL Server 7.0 and I need to create a field that holds a large amount of text (i.e. an article). The only choice I found that was close is the varchar, which holds up to 8000 characters. Is there a better way?<br />