Binary value? 1

[Newbi1]

Hi, I am trying to write a view for a report and have come acros a field that is displaying <Binary>. This field should be either 01 or 06, but for the life of me I am not sure how to convert it so I can implement the view.

 

[vongrunt]

Run the same query (SELECT * from myTable) in Query Analyzer. What's inside this column?

Other than that, you can try CONVERT(varchar(2), binaryColumn)


------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba