I'm trying to create a formula column to search for a piece of text in a field using an IF statement, and return a value.

Normally in SQL I would do something like IF("column" like '%abc%', 1, 0) but that doesn't seem to work.

From what I can tell it's case sensitive in Zoho Analytics. Sometimes the field will have "abc" or "ABC" or "Abc" but when I do the above formula, Analytics only seems to return the exact match, that is "abc" and not the rest.

Any help on this would be appreciated.