SQLQueries SQL Server Queries There are many ways to fetch first 5 characters of the string -. Ans Select SUBSTRING(StudentName,1,5) as studentname from student 1 Select RIGHT(Studentname,5) as studentname from student