sql server mseq: I am looking at a table, using Enterprise Manager, that has several fields
defined
as Binary. All I seem to be able to see is the literal "<Binary>" in these
fields.
How can I view the actual values in these fields? How do I do a selection
criteria on them?

Thanks,
Tom

[quoted text, click to view]

Hi Tom,

Use Query Analyzer instead of Enterprise Manager.

CREATE TABLE test
(a int NOT NULL PRIMARY KEY,
b varbinary(80) NOT NULL)
go
INSERT INTO test (a, b)
SELECT 1, CAST(123435 AS varbinary(80))
go
-- Display binary data
SELECT b
FROM test
WHERE a = 1
go
-- Selection based on binary data
SELECT a
FROM test
WHERE b = 0x0001E22B
-- or: WHERE b = CAST(12345 AS varbinary(80))
go
DROP TABLE test
go


Best, Hugo
--