How can I view the contents of sql binary data fields?

Question

Does anybody know of a free utility that I can use to view the contents of fields containing binary data in an MS SQL Server 2005 database?

Answer 1

Depends if it is just text stored as binary or not, if it is then take a look at this

create table #bla (col1 varbinary(400))

insert #bla values(convert(varbinary(400),'abcdefg'))

select col1,convert(varchar(max),col1)
from #bla

output 0x61626364656667 abcdefg

Answer 2

Do you have anyother option to set which would display 0xa1231el57ld15 when you use Open Table option? I miss SQL server 2000 now :(