I need to select the rows that contain non alphanumeric values in names. I got part of the solution, but, I am also getting rows with spaces, hyphens and single quotes. So, I need to pull the rows with that are alphanumeric and also not pull rows with space and `-` and `'`. 

Did some research online

```
select * 
from EMP  
where NAME like '%[^a-z,1-9]%'

```

I don't want to get rows with `-` or spaces or `'`