In this article, we will explore the working functionality of the SQL Server SUBSTRING function, starting with syntax and basic variable examples. In the later section, we show how to use it on columns, extract text before and after, and find domain names from Email.