I still don't understand why you're using binary instead of smallint or tinyint.

>I need the right 2 characters from the data 00 - ff. I do not know how to get that from the number. It is being used as a counting mechanism. I have 200 + items that need to be counted in a two char space. This is the way I thought would work the best. Otherwise I will need to make a table with a list in it and use that. (unless a better suggestion is made).
>
>>Would converting to a number work for you?

SELECT CAST(@hex AS int)

>>