TSQL Challenge 73 - Implement Word Wrapping in TSQL
The challenge is to wrap long text sequences to a specified overall width (wrap position) - similar to columns in a newspaper.
http://beyondrelational.com/puzzles/challenges/107/implement-word-wrapping-in-tsql.aspx