Microsoft KB Archive/112690

FIX: Nested STUFF Functions Return NULL

PSS ID Number: Q112690 Article last modified on 10-31-1994

4.20

WINDOWS

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.