Some difficulty finding info on except arguments in SQL. This query works up to line 3. Adding line 4 causes a syntax error . Some resource at EE says there is no "except" in SQL??? Can this query be written another way?
SQL = SQL & " select [PD_PatID], [PD_FName], [PD_LName]"
SQL = SQL & " from PATIENT_DETAILS"
SQL = SQL & " where [PD_Diabetic] = True"
SQL = SQL & " except where [PD_Addr1] LIKE '*Tricare*'"