work with binary

[riska]

please, does anybody clue why it doesn't works:
(I've taken it from MSDN)

DECLARE @mybin1 binary(5), @mybin2 binary(5)
SET @mybin1 = 0xFF
SET @mybin2 = 0xA5

SELECT CAST(@mybin1 AS varchar(5)) + ' '
+ CAST(@mybin2 AS varchar(5))

It'll show nothing. (Convert binyry data type to varchar returns a empty string)
I tried this sample because I need to insert binary data from table into a file.

Thanks very much

 

[rt63]

declare your variables as varbinary instead of binary and it should work.

DECLARE @mybin1 varbinary(5), @mybin2 varbinary(5)


RT