Guys, is there a way to use the following but where the statement shows 'And Servtext IN ('WAR' ,'WARTEC' ,'TRIAGE' ,'LAB' ,'BDIAG')' change this to a like statement. Obliviously And Servtext LIKE (%'WAR' ,'WARTEC' ,'TRIAGE' ,'LAB' ,'BDIAG'%) is not correct?Thanks
SELECT *
FROM Bookings
WHERE Created >= '2017-01-01'
AND Created < '2018-01-01'
AND DEALER in ('CA', 'BAA', 'BA')
AND Servtext IN ('WAR' ,'WARTEC' ,'TRIAGE' ,'LAB' ,'BDIAG')
ORDER BY ServCode
Obliviously, huh? 🙂
I think you'll need to expand that out:
And (Servtext LIKE '%WAR%' OR Servtext LIKE '%WARTEC%',...)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.