SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by fediori / Convert string Hex to Numeric with inline TSQL / Latest Posts

RE: Convert string Hex to Numeric with inline TSQL

Carlo Romagnano — Fri, 18 Jan 2013 04:09:11 GMT

[quote][b]Federico Iori (8/8/2012)[/b][hr]A faster way to convert Hex to Dec is select CAST(CONVERT(VARBINARY, 'FF00FF', 2) AS INT)The string to convert must be at least 2 chars long : select CAST(CONVERT(VARBINARY, 'F', 2) AS INT) : errorselect CAST(CONVERT(VARBINARY, '0F', 2) AS INT) : 15 [/quote]the faster and faster:select CONVERT(VARBINARY, 'fffe', 2)+0 --implicit cast

RE: Convert string Hex to Numeric with inline TSQL

Federico Iori — Mon, 17 Dec 2012 07:08:07 GMT

To convert fast from INT to HEX : right(master.dbo.fn_varbintohexstr(cast( Disconnection_cause as INT) ),2)

RE: Convert string Hex to Numeric with inline TSQL

Federico Iori — Wed, 08 Aug 2012 08:11:38 GMT

A faster way to convert Hex to Dec is select CAST(CONVERT(VARBINARY, 'FF00FF', 2) AS INT)The string to convert must be at least 2 chars long : select CAST(CONVERT(VARBINARY, 'F', 2) AS INT) : errorselect CAST(CONVERT(VARBINARY, '0F', 2) AS INT) : 15

Convert string Hex to Numeric with inline TSQL

Federico Iori — Tue, 08 Nov 2011 20:04:46 GMT

Comments posted to this topic are about the item [B]Convert string Hex to Numeric with inline TSQL[/B]