the substring function in sql server

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