>>>>I am wondering about the Text type of field. When is it appropriate to use Text type versus maybe VarChar(Max)?
>>>>Tim
>>>
>>>Text is deprecated - they want you to use varchar(MAX) now.
>>
>>Perfect that answers it Paul.
>>Tim
>
>Be careful with this if you use ODBC drivers.
>
>The SQL Server Native Client 10.0 ODBC driver doesn't work with varchar(MAX)

Thanks Brandon, I will test my situation.
Tim