O soluţie presupune folosirea funcţiei PATINDEX ca în exemplul următor:
SELECT *
FROM
(
SELECT 'Georgescu1' AS Nume, 'George' AS Prenume, 8 AS Nota
UNION
SELECT 'Popescu ' AS Nume, 'Popa' AS Prenume, 10 AS Nota
UNION
SELECT 'Vasilescu' AS Nume, 'Vasile' AS Prenume, 9 AS Nota
) AS Tabela
WHERE PATINDEX('%[^a-z]%',Nume) != 0