extracting not null

[scarlsen30]

I need to find a way to extract all not null fields from a table.

i tried

SELECT last_name, first_name
FROM ssfeatured
WHERE last_name NOT NULL
ORDER BY last_name

but i get a syntax error.

any help would be appreciated.