Very Computer

I am an Ex-Clipper programmer and I am trying to create an application
using Delphi and MS SQL Server 6.5.  In Clipper, there is a 'Memo' datatype
that is variable length allowing me to use it to store general text
information.  Is there an equivalent datatype in MS SQL Server?

Thanks,
Kevin Meier

Kevin,

varchar for up to 255 characters.  Over that, there is a TEXT type.

 Protech Computing Ltd (MS Solution Provider)
 Using Virtual Access 3.52 build 159c (32-bit) on NT 4.0 SP2

Note that there is a BUG on TEXT columns, though.

http://www.microsoft.com/kb/articles/q152/0/52.htm

--=20
{~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~}
{ :)  Jos=E9 Nuno de Abreu Pires dos Santos Ferreira  :( }
{                                                      }
{ PESSOAL / PERSONAL --------------------------------- }

{                                                      }
{ EMPREGO / JOB -------------------------------------- }
{      Home Page: http://homepage.esoterica.pt/~sinfic }



{                                                      }
{~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~}