Biggest issue Text fields is that there are a number of search limitations that don't exist for char/varchar fields.
+++ Rick ---
>I was migrating code that made extensive use of Date fields so upsizing was just easier to use the new odbc driver and the text fields instead of varchar(max). I use the text fields in full-text indexes without issue. I've not found any negatives using text fields despite the ongoing threat of deprecation.
>
>
>
>>Can you make the SQL dates DateTime values? Or else when you query explicitly add the conversion to DateTime values in the queries by casting.
>>
>>+++ Rick ---
>>
>>>Pick your poison:
>>>Old odbc driver works with varchar(max) but not date
>>>New odbc driver works with date but not varchar(max), you have to use Text instead