Compare two IMAGE fields

• issam mansour

  SSC-Addicted

  Points: 478

  More actions

  September 10, 2008 at 12:54 pm

  #93815

  Hi,

  how to Compare two IMAGE fields, i try the following:-

  SELECT itemphoto.item_no, itemphoto.photo

  FROM [2560].[2560].itemphoto itemphoto ,[erpinv41].[ims].itemphoto MAINPHOTO

  where itemphoto.photo <> MAINPHOTO.photo

  but i get the follwoing error:-

  Msg 402, Level 16, State 1, Line 1

  The data types image and image are incompatible in the not equal to operator.

  best regards

• Gary Johnson-259336

  SSCommitted

  Points: 1673

  More actions

  September 10, 2008 at 2:57 pm

  #869987

  Convert the image field to varbinary to do your comparison.

  create table foo

  (

  img image

  )

  go

  select *

  from foo a, foo b

  WHERE convert(varbinary,a.img) = convert(varbinary,b.img)

  Gary Johnson
  Sr Database Engineer