I'll recommend again that you get a copy of Books Online (BOL for short) and use it. It clearly stated under the TEXT datatype that it is what has been deprecated and not VARCHAR(MAX). Learn to use the "INDEX" feature. It will save you much heartache and wasted time.
--Jeff Moden
Change is inevitable... Change for the better is not.