ms sql substring string code example

Example 1: sql server substring

SELECT SUBSTRING('SQL Tutorial', 1, 3) AS ExtractString;

Example 2: how to fetch first 5 characters in sql

Select SUBSTRING(StudentName,1,5) as studentname from student