This blog is officially retired. Please visit http://sqlblog.com.
For string-manipulating fun:
Splitting a string of unlimited length
Counting occurrences of a substring within a string
Enjoy!