Jerry Nixon on Windows: TSQL to split words based on uppercase

Jerry Nixon on Windows

Tuesday, July 19, 2011

TSQL to split words based on uppercase

There are cases where data in the database is concatenated and you need to parse it back to proper spacing. In this routine, pass in 'JerryNixon' and get 'Jerry Nixon'. Yeah!

CREATE FUNCTION dbo.fn_SpacePascal(@in varchar(500))

See all the code here: http://codepaste.net/a8g161