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......