Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Converting Binary Strings into NUMERIC or FLOAT

By: FYIcenter.com

(Continued from previous topic...)

Can Binary Strings Be Converted into NUMERIC or FLOAT Data Types?

Can binary strings be converted into numeric or float data types? The answer is no. Binary strings can not be converted implicitly or explicitly into NUMERIC, DECIMAL, REAL, or FLOAT data types.

The tutorial exercise gives you some examples of errors when converting binary strings to NUMERIC or FLOAT data types:

-- Implicit conversion to NUMERIC
SELECT 0x66 + 0.44;
GO
Msg 8114, Level 16, State 5, Line 1
Error converting data type varbinary to numeric.

-- Explicit conversion to NUMERIC
SELECT CONVERT(NUMERIC(9,2), 0x66) + 0.44;
GO
Msg 8114, Level 16, State 5, Line 1
Error converting data type varbinary to numeric.

-- Implicit conversion to REAL
DECLARE @real REAL;
SET @real = 0x66;
Msg 206, Level 16, State 2, Line 2
Operand type clash: varbinary is incompatible with real

-- Implicit conversion to FLOAT
DECLARE @float FLOAT(53);
SET @float = 0x66;
Msg 206, Level 16, State 2, Line 2
Operand type clash: varbinary is incompatible with float

(Continued on next topic...)

  1. How To Concatenate Two Character Strings Together?
  2. What Happens When Unicode Strings Concatenate with Non-Unicode Strings?
  3. How To Convert a Unicode Strings to Non-Unicode Strings?
  4. What Are the Character String Functions Supported by SQL Server 2005?
  5. How To Insert New Line Characters into Strings?
  6. How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions?
  7. How To Concatenate Two Binary Strings Together?
  8. Can Binary Strings Be Used in Arithmetical Operations?
  9. How To Convert Binary Strings into Integers?
  10. Can Binary Strings Be Converted into NUMERIC or FLOAT Data Types?
  11. Can Binary Strings Be Converted into Character Strings?
  12. Can Binary Strings Be Converted into Unicode Character Strings?
  13. How To Convert Binary Strings into Hexadecimal Character Strings
  14. What Are Bitwise Operations?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...