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

• Next in forum: Re: delete database file on server -> sharing violation
• Prev in forum: Run SQL script on Instance Startup
• Thread view: Re: Replace Multiple Spaces with One Space?

[Reply to this message]