What SQL Server version are you using?
>I'm getting "Incorrect syntax near 'MAX'"
>
>This looks like a constant.
>
>
>
>
>
>>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)
--sb--