huh?

My question is about the keyword 'MAX' - it looks like a constant.

BOL shows an optional parameter to varchar. I assume 'MAX' is a constant
you created?





>As I mentioned in one of previous messages, it's new type implemented in SQL 2005.
>
>>2000
>>
>>>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.