just incase you need it.
Here is a solution for if you data is stored in table and you want to do more than one row at a time.
DECLARE @table TABLE
(Input VARCHAR(MAX))
INSERT INTO @Table
SELECT 'IReallyHopeThisWorks.' UNION ALL
SELECT 'IfNotPleaseLetMeKnow'
SELECT
STUFF((SELECT
CASE
WHEN PATINDEX('%[A-Z]%',SUBSTRING(Input,N,1) COLLATE Latin1_General_BIN) != 0
THEN ' ' + SUBSTRING(Input,N,1)
ELSE SUBSTRING(Input,N,1)
END
FROM Tally WHERE N <=LEN(Input) FOR XML PATH('')),1,1,'')
FROM @table
This also uses a tally table
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]