get substring from string in sql

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