Things I have tried
WHERE contains(Role, "Protagonist") AND !contains(Role, "Historical" AND "Secondary")
What I’m trying to do
I’m attempting to exclude characters’ from a table of my story’s protagonists that contain the word “Secondary” or “Historical.”
So, if the code was working, it would render characters who have the role “Protagonist” but not characters who have the role “Secondary Protagonist” or “Historical Protagonist.”
As you can see above, I wrote an SQL query that I thought would achieve this, but the code does not work and all the characters with “Protagonist” within their Role display (including those with “Secondary” and “Historical”).
Could anyone help me understand how to include to strings to test against ina contains statement?
Thanks!