• 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]