CODEWITHSUNDEEP
sql-serversql-server-2008t-sql
Corovei Andrei
Corovei Andrei

Reputation: 1668

Convert hexadecimal value into bigint

I am getting some trouble converting a string (representing a hexadecimal number) into a bigint. I would also like this to happen inside a function and as effiecient as possible. Is there anyway of exploiting the built-in functions? Here is an example of what I want to do:

select convert (bigint, '0000010d1858798c')

Upvotes: 5

Views: 7818

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300719

The SQL Server 2008 release updated the CONVERT() function to be able to convert hexadecimal values:

select convert(bigint, convert (varbinary(8), '0x0000010d1858798c', 1))

Result:

1155754654092 (decimal) ( ==  0x0000010d1858798c )

Upvotes: 9

Related Questions