Michel,

If you migrated to SQL 2000, text was the only datatype that would make sense to use for a VFP memo field, because of it's almost unlimited size (well, right around 2GB).

Now, with SQL 2005, there's a new version of varchar, specified as VARCHAR(MAX) and that's what you should be using now. I don't know why they came up with this MAX concept. It stores the same amount of data as the old text data type, but text is going to be removed in the future. Straight out of BOL:

ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

~~Bonnie


>When I migrated two of my applications to SQL Server, a while ago, whatever was memo fields ended up to be within a Text type. However, a client of mine is wondering why we are not using VarChat for that? Anyone would like to comment on that?