This UDF returns a multi column table of values from an input string of comma separated values  Read more...

This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function.  Read more...

Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.  Read more...

Like my tdard split but this will take a string and split it by 2 delimiters  Read more...

In the simplest terms, a user-defined function (UDF) in SQL Server is a programming construct that accepts parameters, does work that typically makes use of the accepted parameters, and returns a type of result. This article will cover two types of UDFs: table-valued and scalar-valued.  Read more...