Just for completeness,
there is an undocumented extended stored procedure converting hex to int
DECLARE @dec varbinary(10)
DECLARE @result varchar(255)
SET @dec = 813185089
EXEC master..xp_varbintohexstr @dec, @result OUT
PRINT @result
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]