Functions are very handy. They can also prove to be the cause of poor performance (such as was the case with that string splitter). When used appropriately, you can provide well-performing SQL as well as some very handy information.
T-SQL Tuesday #024: Prox ‘n’ Funx