Hi,
I have query where i need to use group by for column whose datatype is image
but it throws an error
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
Even ,i tried to convert in iamge column in varbinary or varchar bout nothing helped me.
My query is as follows
select item_img,count(item_code) from dbo.item_master group by item_img
Here item_img data type is image