Is this better?
SELECT
DATENAME(dw, [Date]) AS 'Day This Data Was Entered'
, [Date]
, ([notes]) --, *
FROM
[Logs]
WHERE
[Notes] NOT LIKE '%' + DATENAME(dw, [Date]) + '%'
--And (Notes like '%Attended - %' Or Notes like '%Came to %' or Notes like '%Came on%' or Notes like '%Attedned%')
--And Notes Not like '%Make-up class%'
--Ensure Weekdays are included in the Notes
AND
(
[Notes] LIKE '%Monday%'
OR [Notes] LIKE '%Tuesday%'
OR [Notes] LIKE '%Wednesday%'
OR [Notes] LIKE '%Thursday%'
OR [Notes] LIKE '%Friday%'
OR [Notes] LIKE '%Saturday%'
OR [Notes] LIKE '%Sunday%'
)
--Ensure Most Common are excluded from the Notes
AND
(
[Notes] NOT LIKE '%Little Eagles%'
AND [Notes] NOT LIKE '%Beginners%'
AND [Notes] NOT LIKE '%Inter/Adv%'
AND [Notes] NOT LIKE '%Adult%'
AND [Notes] NOT LIKE '%Black Belt class%'
AND [Notes] NOT LIKE '%Int/Adv%'
AND [Notes] NOT LIKE '%Intermediate/Advanced 7:30pm%'
AND [Notes] NOT LIKE '%Saturday 10:30am class%'
AND [Notes] NOT LIKE 'Attedned%'
AND [Notes] NOT LIKE 'Attended%'
AND [Notes] NOT LIKE 'Attedended%'
AND [Notes] NOT LIKE '%Black Belt/MC Class%'
AND [Notes] NOT LIKE '%Master Kim Private lesson%'
AND [Notes] NOT LIKE '%Attended%'
AND [Notes] NOT LIKE '%Attended%'
AND [Notes] NOT LIKE 'Came To Class%'
AND [Notes] NOT LIKE 'Came Last%'
AND [Notes] NOT LIKE '%came to youth class instead of LE class.%'
AND [Notes] NOT LIKE '%Attended%'
AND [Notes] NOT LIKE '%Came on%'
AND [Notes] NOT LIKE '%Came to%'
AND [Notes] NOT LIKE '%Cameto%'
AND [Notes] NOT LIKE 'Cameto%'
AND [Notes] NOT LIKE 'Was %'
AND [Notes] NOT LIKE '%ttended%'
AND [Notes] NOT LIKE 'came %'
AND [Notes] NOT LIKE '%Attended%'
)
ORDER BY
[Notes];