Posted by Blackburn on 10/18/07 17:05

"Russ Rose" <russrose@hotmail.com> wrote:
>


How did you guys miss the recursion boat?

Create function dbo.udf_CondenseSpaces (@str varchar(8000))

Returns varchar(8000)
AS

BEGIN
Declare @s varchar(8000)

Set @s = replace(@str, ' ', ' ')

if charindex(' ', @s) > 0

set @s = dbo.udf_CondenseSpaces(@s)

return @s
END

[Back to original message]