This blog is officially retired. Please visit http://sqlblog.com.
In the category of things you probably shouldn't do...
Validate a URL from SQL Server
For string-manipulating fun:
Splitting a string of unlimited length
Counting occurrences of a substring within a string
Enjoy!