Microsoft KB Archive/141664

= BUG: Convert From Binary to Numeric Gives Error 8114 =

Article ID: 141664

Article Last Modified on 3/2/2005

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.