BUG: Convert of Local Variable of Type Float or RealLast reviewed: April 28, 1997Article ID: Q89825 |
The information in this article applies to:
SYMPTOMSIf you use the convert function on a local variable of type float or real and the assigned value is NULL, the convert function will incorrectly convert the NULL value to a character string that is a "0". For example:
declare @f float select @f = NULL select @f, convert(char(20), @f) --------------- ----------------- NULL 0The following is what should have been returned:
--------------- ----------------- NULL NULLThis behavior occurs only with local variables of type float or real. If these are fields in a table, the convert functions correctly.
STATUSMicrosoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
|
Additional query words: Transact-SQL
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |