General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only