Marco,
This is just a quickie off the top of my head, so, experiment first and if it doesn't go as I indicate, I apologize for wasting your time.
I'd try {#genre:contains('SF','SFFF',''} (that's TWO SINGLE QUOTES typed without a space). Now, you can STACK the test. {#genre:contains('SF','SFFF',{#genre:contains('MYS ','MYS&THR'}} if you want, but be careful. I'd start in a text editor and then make sure my brackets were there as you compose a seriously compound test for a custom column. When you have that all looking right, THEN I'd work on a copy, delete all carriage returns and extraneous spaces and use that to test. (just some experience talking)
The key is that Null doesn't seem to be useful to what you are trying to do in terms of returned result. But I could be wrong. It's forever since CHaley guided my way through the template language for plugboards and custom columns.
Now, if you want a compound RESULTS column, where it can be SFFF AND MYS&THR, then you have to sequentially run each test and add to the result when you get each positive. That's a program, which Calibre can do. I'll leave you to look it up.
Hope that helps a little, GM
|