Understand how to use the SQL Server SUBSTRING function for extracting text. Includes examples with tables, dynamic extractions and tips.