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