Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.  Read more...

I see charindex used quite commonly in string manipulation.  What I rarely see used is the optional third parameter.  Here...  Read more...