How to extracts a substring with a specified length from string in SQL

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