SELECT DISTINCT Fname FROM STUDENT WHERE Fname LIKE '%a%'
Find the first names of students whose first names contain letter "a".
SELECT DISTINCT Fname FROM STUDENT WHERE Fname LIKE ' % a % '
select distinct fname from student where fname like value
Find the first names of students whose first names contain letter `` a '' .