SELECT DISTINCT pName FROM Player WHERE pName LIKE '%a%'
Find the players whose names contain letter 'a'.
SELECT DISTINCT pName FROM Player WHERE pName LIKE ' % a % '
select distinct pname from player where pname like value
Find the players whose names contain letter 'a ' .