CODE EXAMPLE FOR SQL

fetch first 5 characters of the string in sql

Select SUBSTRING(names,1,5) as studentName from student