This SQL statement
SELECT MAX(DISTINCT ProductVersion) AS New, ProductType, ProductDesc, CAST(ProductLogo AS varbinary)
FROM eProducts
GROUP BY ProductType, ProductDesc, ProductLogo
gives me this error
Server: Msg 306, Level 16, State 2, Line 1
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
How can I retrieve the above record? ProductLogo is an image column.