It was created in SQL 2005 to overcome the text data type limitations, like inability to manipulate them in full in T-SQL, e.t.c.

>Whats the difference between this and Text?
>
>
>
>>>How do you create a memo field in SQL Server?
>>
>>

varchar(MAX)