You can use the COALESCE() function. It will return the first non null value in the list of values you pass in.
For example:
SELECT name, COALESCE(a,b,c) AS someField
FROM table
will return a if it is not null and if a is null it will return b if not null, etc.