How to use SUBSTRING () function in Sql Server

SUBSTRING () - Extract characters from a text field

Example: - Below is the simple example of SUBSTRIGN function

DECLARE @STRING VARCHAR(50)='EXAMPLE OF SUBSTRING FUNCTION'

SELECT SUBSTRING(@STRING, 1, 7)

This gives the Result: - EXAMPLE