command used to fetch first 5 characters of the string in sql code example

Example: how to fetch first 5 characters in sql

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