About
Digital Colony is the technical web site for Michael Allen Smith of Seattle.
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
