>Hi,
>
>I came across an issue with Text type column that UPPER() function (that is used a lot in my app) does not work on Text but works on Varchar(max). Before I go ahead and change all my memo fields (in SQL Server) to Varchar(max), is there a downside of not using Text for memo? TIA.

The Text type has been deprecated in future versions so you have to get rid of that. There is a gotcha in the transition involving SQL Server's version of memo fields. You have to access them separately. If someone doesn't jump in and clarify that I can dig through my archives.