where() clause with Contains() in Data Filter

[vitali_pom]

Hi,

When I try to do the following, I get an exception:

dt1 << Data Filter(
  add Filter(
  columns(:MyCol),
  Where( contains(:MyCol, "A12") > 0)
  ),
  mode(show(1))
) << invert row selection;

And I get the following exception:

The WHERE clause has not been correctly specified. in access or evaluation of 'Greater'

How to accomplish what the code tries to do properly?

[RW9]

Hi,

You may want to post on: https://community.jmp.com/welcome

[vitali_pom]

Thanks! Asked it here: https://community.jmp.com/message/212239#212239