SQL
      Back to home
      1. Help Center
      2. SQL

      What is the command used to fetch first 5 characters of the string?

      There are many ways to fetch first 5 characters of the string -.
       
      Select SUBSTRING(StudentName,1,5) as studentname from student
      Select LEFT(Studentname,5) as studentname from student