Hey All,

Please check out this tip:

http://www.mssqltips.com/tip.asp?tip=2297

Sample run:

select dbo.ReplaceMatch(

'1 space 2 spaces 3 spaces 4 spaces no space(s)', ' {2,}', ' ')

returns:

-----------------------------------------------------

1...

Try running these scripts in Denali; can't beat SSMS editor 😉

Ron,

It's amazing what people did with dBaseIII+; I was one of them back in the day :>)

Thanks for y'all comments so far.

I plan to put an interface on the sprocs - maybe WP7 to beat the iPhone?