Display the Student Name whose name is having the third letter as ‘A’

Sometimes we may need to extract specific positioned characters from a string....
The below code is fetching student details who have the character 'A' as third letter in their name.

SELECT * FROM Student WHERE Name like '__a%' 

Another real-time example for this kind of requirement is,

The SBI KIT NUMBER consists of Package Number and Serial Num together

Package Number is ZZ661 and Serail Number is 0043 then the SBI KIT NUMBER is ZZ6610043

If you needed to find out specific serail numbered KITs, then you can search as above......