Microsoft KB Archive/89825

{|
 * width="100%"|

The information in this article applies to:
 * Microsoft SQL Server version 4.2 for OS/2

BUG# OS/2: 1516 (4.2)

SYMPTOMS
If 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 &quot;0&quot;.

For example:

declare @f float select @f = NULL select @f, convert(char(20), @f)

--- -             NULL 0 The following is what should have been returned: --- -             NULL NULL This behavior occurs only with local variables of type float or real. If these are fields in a table, the convert functions correctly.

STATUS
Microsoft 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.
 * }

-

Last reviewed: April 28, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.