Cannot find a way to implement WHERE ADDRESS IS NOT NULL, or even ADDRESS IS NULL. Here is the recordset:
SELECT LASTNAME, FIRSTNAME, MAIDENAME, ADDRESS, CITY, ZIP, EMAIL, YEAR, DECEASED
WHERE LASTNAME LIKE '%varLname%' OR FIRSTNAME LIKE '%varFname%' OR MAIDENAME LIKE '%varMname%' OR CITY LIKE '%varCity%' OR ZIP LIKE '%varZip%' OR EMAIL LIKE '%varEmail%' OR YEAR LIKE '%varYear%' OR DECEASED LIKE '%varDeceased%' OR ALUMNI_ID LIKE '%varAlmnID%'
Have tried several ways of including IS NOT NULL and IS NULL into this syntax, but all has failed.
Yes I know, DW MX is old. But so is the server. This is not the problem.