Knowledge Base

BUG: Convert From Binary to Numeric Gives Error 8114

Article ID: 141664

Article Last Modified on 3/2/2005

Microsoft SQL Server 6.0 Standard Edition
Microsoft SQL Server 6.5 Standard Edition
Microsoft SQL Server 7.0 Standard Edition
Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q141664

BUG#: 12244 (SQLBUG_60)
BUG#: 19019 (SQLBUG_65)
BUG#: 57913 (SQLBUG_70)

SYMPTOMS

The SQL Server 6.0 "Transact-SQL Reference" manual states, on page 189, that binary can be explicitly converted to numeric, however, using the Convert() function to convert from binary to numeric gives the following error:

Msg 8114, Level 16, State 2
Error converting type binary to type numeric.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The following script will replicate the problem:

declare @x numeric
declare @y binary
select @y = 0x00
select @x = convert(numeric, @y)
select @x

Additional query words: SQL6 winnt prog convert doc

Keywords: kbbug kbusage KB141664