Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/100600

From BetaArchive Wiki

BUG: Nested STUFF() Functions Return NULL

Q100600



The information in this article applies to:


  • Microsoft SQL Server version 4.2x



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 SQL Server SQL Server version 4.2.

Additional query words:

Keywords : kbprogramming
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2


Last Reviewed: November 9, 1999
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.