Tag Archives: hexadecimal

Convert Hexadecimal to Integer in SQL

Below is a handy function for converting a hexadecimal value into an integer using a SQL Server user defined function. IF OBJECT_ID(‘dbo.udfHex2Int’) IS NOT NULL DROP FUNCTION dbo.udfHex2Int GO CREATE FUNCTION dbo.udfHex2Int ( @hexstr AS varchar(1000) ) — Function converts … Continue reading

Posted in SQL | Tagged , | Comments Off