>>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.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham