The title says it all. HEXTOINT can only convert integers up to 32 bit. I need to convert a 48 bit-long number from hex to decimal and viceversa. asked 23 Feb '11, 13:54 Sergio Volker Barth |
BEGIN DECLARE @hex VARCHAR ( 100 ); DECLARE @bigint BIGINT; SET @hex = '7048860DDF79'; EXECUTE IMMEDIATE STRING ( 'SET @bigint = CAST ( 0x', @hex, ' AS BIGINT )' ); SELECT @bigint; END; @bigint 123456789012345 answered 23 Feb '11, 14:17 Breck Carter |
Another option, inspired by Breck's solution:
answered 24 Feb '11, 14:58 Bruce Hay |