From: m on
Sorry I lost track, but knew that the MAX versions were new. I hardly ever
work with these types except in scenarios that require compatibility with
ancient versions.

"Kalen Delaney" <please_reply_on_newsgroups(a)domain.com> wrote in message
news:E08E09D1-60CD-4066-AA2B-19CE479EF6B5(a)microsoft.com...
> varchar(MAX) and varbinary(MAX) were added in SQL Server 2005.
> Text and image are deprecated.
>
> --
> HTH
> Kalen
> ----------------------------------------
> Kalen Delaney
> SQL Server MVP
> www.SQLServerInternals.com
>
> "m" <m(a)b.c> wrote in message news:en5ZnSunKHA.1556(a)TK2MSFTNGP05.phx.gbl...
>> Also note that image has been superseded by varbinary(max) in SQL 2008.
>> If you are using an older version, then you should use image
>>
>> "Plamen Ratchev" <Plamen(a)SQLStudio.com> wrote in message
>> news:hIGdnYsfOdpbv8LWnZ2dnUVZ_opi4p2d(a)speakeasy.net...
>>> It is best to use VARBINARY(MAX). On SQL Server 2008 you can use
>>> FILESTREAM, but for small images probably just VARBINARY(MAX) is fine.
>>>
>>> --
>>> Plamen Ratchev
>>> http://www.SQLStudio.com
>>