SELECT CAST(REPLACE('0x0000000000000028', '0x', '') AS INT)

SELECT CAST(CAST( '0x0000000000000028' AS VARBINARY(64)) AS INT)

quote:

---

Originally posted by visakh16

how will '0x0000000000000028' be equal to 28 int?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by Transact Charlie

quote:

---

Originally posted by visakh16

how will '0x0000000000000028' be equal to 28 int?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

Yeah -- my bad -- didn't really think of the consequences. Anyway casting to an intermediate VARBINARY works?


Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

---

quote:

---

but wont give you correct value. wouldnt result be 40?

---

quote:

---

Originally posted by Transact Charlie

quote:

---

but wont give you correct value. wouldnt result be 40?

---

Just realised this myself. It would give you an int value that you could turn back into the character representation of a binary 0028 but that's probably worse than useless. :(

It's been a long day.


Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

---

CREATE FUNCTION HexStrToInt
 (
 @HexVal varchar (30)
 )
 RETURNS int
 AS
 BEGIN
DECLARE @IntVal int

SELECT  @HexVal=REPLACE(@HexVal,'0x','')

select @IntVal=
sum(
      case lower( substring( reverse(@HexVal), number , 1 ) )
 when '0' then 0
 when '1' then 1
 when '2' then 2
 when '3' then 3
 when '4' then 4
 when '5' then 5
 when '6' then 6
 when '7' then 7
 when '8' then 8
 when '9' then 9
 when 'a' then 10
 when 'b' then 11
 when 'c' then 12
 when 'd' then 13
 when 'e' then 14
 when 'f' then 15
      end *  power( cast(16 as bigint), number - 1 )
)
from master..spt_values n
where type='p'
and  number between 1 and len( @HexVal )

RETURN @IntVal
END
 
and use it like

 select dbo.HexStrToInt('0x0000000000000028')

output
--------------------
40