How to see contents of image column

[Marcel]

Hello,

In my MS SQL SERVER database i have an column with datatype image. Some
records do have data in this column, some others don't. When i look at this
table in Enterprise Manager then i see in every field '<image>' so no way to
see directly wheter a filed has data or not. Is there a way to change
display of this column so i can see the binairy data in it?

Marcel

[Dan Guzman]

In don't know about EM but you can query the data using Query Analyzer to
see the data in hex representation.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Marcel" <ge******@hottentottententententoonstellingen.co m> wrote in message
news:16**************************@news1.zonnet.nl. ..

Hello,

In my MS SQL SERVER database i have an column with datatype image. Some
records do have data in this column, some others don't. When i look at
this
table in Enterprise Manager then i see in every field '<image>' so no way
to
see directly wheter a filed has data or not. Is there a way to change
display of this column so i can see the binairy data in it?

Marcel