Function to provide String.Format-like functionality

String.Format is an extremely helpful tool in the C# world. Sadly T/SQL seems to lack the same functionality with the same ease of access. The following script will allow you to generate strings much like String.Format does. As noted in the script comments, usage is…