krileon wrote: Can you provide an example of your exact usage that caused it to fail?

See screenshot of syntax error message here:



Note the underlined field name, which in the query code was correctlybut got scrambled by Auto Action (so to speak) toAlso note the single closing quote instead of `. Trust me I've been through a lot of variations of this, all of which - with the exception of this screenshot - I deleted after I figured that CASE WHEN THEN ELSE END works instead.

Thanks as always, Kyle.

Two different IF functions exist for MySQL. See here: dev.mysql.com/doc/refman/5.5/en/if.html - the blue "Note" box early on underlines the fact. Or google "mysql if then" and get a lot more on this other function.

However, I am familiar with the one you're referring to, had also tried it (did work in a very simple format), but when there were nested conditions, other than it getting hard to read it then failed in the same fashion... and I had paid really careful attention to getting the syntax right.

Anyway, we agree it works perfectly fine with CASE, no problem, and that's what matters.

Thanks and cheers!