Fetch first 5 characters of the string

Question

Hi!!

Can someone tell me how to fetch the first 5 characters of the string?

Answer 1

There are a lot of ways to fetch characters from a string. For example:

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