<div>
<div class="content wysiwyg-content">
I have a UNION query that defines a view. &nbsp;One of the columns in the query is a image data type. &nbsp;When I try to save the view, I get this message:<br />
<br />
&quot;The image data cannot be selected as DISTINCT because it is not comparable&quot;. &nbsp;<br />
<br />
I understand how image data is not comparable, but where is the DISTINCT coming from? &nbsp;I am not specifying DISTINCT. &nbsp;Is there a way around this? 
</div>
</div>


I have a UNION query that defines a view.  One of the columns in the query is a image data type.  When I try to save the view, I get this message:

"The image data cannot be selected as DISTINCT because it is not comparable".  

I understand how image data is not comparable, but where is the DISTINCT coming from?  I am not specifying DISTINCT.  Is there a way around this? 

UNION query and image data type

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.