FIX: Nested STUFF() Functions Return NULL
  
PSS ID Number: Q112690
Article last modified on 10-31-1994
 
4.20
 
WINDOWS
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2
----------------------------------------------------------------------
 
BUG# NT: 319 (4.2)
 
SYMPTOMS
========
 
When you attempt to change several characters in a character string
using nested calls to the STUFF() Transact-SQL function, NULL is
returned instead of the expected character string.
 
CAUSE
=====
 
The result of nested STUFF() functions is NULL.
 
WORKAROUND
==========
 
A local variable can be used to eliminate the need for nesting calls
to STUFF(). For example, to change the slash marks in a date to
hyphens, the following Transact-SQL statements could be used:
 
   declare @tempvar char(8)
   select @var = stuff( "01/01/93",6,1,"-" )
   select @var = stuff( @var, 3,1,"-" )
   select @var
 
STATUS
======
 
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 4.2. This problem was corrected in SQL Server version 4.2P33. For
more information, contact your primary support provider.
 
Additional reference words: 4.20 remote procedure RPC ODS Open data
services Windows NT
KBCategory: kbprg
KBSubcategory: SSrvWinNT
 
=============================================================================
 
Copyright Microsoft Corporation 1994.
