I have a customers table with an ID, and two fields for phone number: phone_primary and phone_alternate.
I want to create a query. that will pull up ID and phone which could be primary_phone. However, If primary_phone field has a NULL value, then it should display the phone_alternate instead. But I don't want a 3 column retrieval, and both phone_primary and phone_alternate.
I'm using Access. What's the SQL syntax for such?
I thought I should start with ISNULL() and was able to retrieve 0 and -1 (for False), but not sure where to go from there?