declare @var varchar(8) set @var='0x02BE8B003DB14301' select convert(binary(8), @var)