• 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]

    SQL-4-Life