We’re trying to pull out a list
We DO want to see records with no comments AND records with comments except where the comments contain either %TRNG% or %Training%
We just can’t figure it out. Any ideas?
SELECT <fields including COMMENTS>
DELIVERIES.SERVICE_PERIOD_START >= @SERVICE_PERIOD_START
AND DELIVERIES.SERVICE_PERIOD_START <= @SERVICE_PERIOD_START2
AND DELIVERIES.FUND_IDENTIFIER IN (@FUND_IDENTIFIER)
AND DELIVERIES.SERVICE IN (@SERVICE)
(DELIVERIES.COMMENTS is NULL
OR DELIVERES.COMMENTS <> N'%TRAINING%'))
Also tried a variety of "NOT LIKE" "NOT CONTAINS" and not getting the desired results.
Can anyone help?