This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string.  Read more...

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...

This example return a value with split function  Read more...