I need to scan a field for a specific string and exclude all records with that specific string. This string in the filed looks like this:
'WRK 08:06, LNCH 00:54, GRACE 00:02'
I want to excule all records containg "LNCH" in the time_code field. I tried like but that does not seem to work. Can anyone help?