BUG: Convert From Binary to Numeric Gives Error 8114 (141664)

The information in this article applies to:

Microsoft SQL Server 6.0
Microsoft SQL Server 6.5
Microsoft SQL Server 7.0
Microsoft SQL Server 2000 (all editions)

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

Modification Type:	Minor	Last Reviewed:	3/2/2005
Keywords:	kbBug kbusage KB141664