Reading Image Data

  • 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.

  • Please post your question in an appropriate forum.

    This forum "Question of the Day" is specifically for comments on the Question of the Day (QOD). The QOD is a test question that can be found daily at Resources>Question of the Day.

    -SQLBill

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply