Version Delimiter

Reference: Laurence @ http://stackoverflow.com/questions/13315756/how-to-compare-sql-strings-that-hold-version-numbers-like-net-system-version-cl

Delimiter Split

Source: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4126a010-6885-4eb0-b79c-c798c90edb85/how-to-split-comma-delimited-string

Two variations of the function but the purpose is to determine the difference in dates and display the result in one column. Result: 31 years,5 months,26 days Detailed Credit goes to armen at http://stackoverflow.com/users/395720/armen While his response on this URL isn’t a function it is his code that makes the function work http://stackoverflow.com/questions/11184476/how-to-calculate-age-in-t-sql-with-years-months-days-hours-minutes-seconds