Hex to Decimal conversion

Question

question

viki2015 asked Mar 9, '16

Hex to Decimal conversion

Hi, I wanted to convert 000D-6F00-0260-7C59 into decimal so that the output will look like 3781220527799385. Thanks,

sql-server-2008 sql

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2016-03-09T15:03:05Z

David Wimbush answered Mar 9, '16

I think hextoint must be a user-defined function on your system, viki2015. It's not available on my system. As far as I can see, you have to convert this string into a binary datatype first and then that converts to an int. I don't think there's any implicit conversion from hex to integer. This does the trick: DECLARE @a VARCHAR(20) = '000D-6F00-0260-7C59'; DECLARE @b VARBINARY(22) = CONVERT(VARBINARY(22), '0x' + REPLACE(@a, '-', ''), 1); SELECT @b; SELECT CONVERT(INT, @b);

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

viki2015 commented · Mar 09, 2016 at 03:43 PM

You are right. just little change SELECT CONVERT(BIGINT, CONVERT(VARBINARY(22), '0x' + REPLACE('000D-6F00-0260-7C59', '-', ''), 1));

0 ·

Answer 2 · 2016-03-09T13:29:51Z

viki2015 answered Mar 9, '16

DECLARE @a VARCHAR(20) = '000D-6F00-0260-7C59' SELECT db_name.dbo.hex2int(REPLACE(@a, '-', ''))

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question