XLeratorDB/engineering Online Documentation
Updated: 27 August 2010
Use EBIN2DEC to convert an unsigned positive binary number to decimal.
Syntax
SELECT [wctEngineering].[wct].[EBIN2DEC] (
<@Number, nvarchar(4000),>)
Arguments
@Number
is the positive binary integer you want to convert. @Number is an expression of type nvarchar or of a type that can be implicitly converted to nvarchar.
Return Types
varchar(4000)
Examples
select wct.EBIN2DEC(0101010010101110)
This produces the following result
----------------------
21678
(1 row(s) affected)