The following queries demonstrate the T-SQL SUBSTRING function. I've also included a comparison with the C# function of the same name. Unlike C#, the T-SQL SUBSTRING is 1 based. [code language="sql"] print substring('a,b,c,d', 1, 1); -- RETURNS: a [/code] Unlike C#, SUBSTRING's 3rd parameter is NOT optional. You can't leave it blank if you want … Continue reading T-SQL Review: SUBSTRING