How to extract a part of string using substring function in SQL

SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.