crosspost from http://blogs.msdn.com/rextang Here is some conversion functions in SQL Server... To convert between int and hex values, by referring to this post : SELECT 'Int -> Hex' SELECT CONVERT(VARBINARY(8), 16777215) SELECT 'Hex -> Int' SELECT CONVERT(INT, 0xFFFFFF) To convert...