>Hi
>
>I would like to set filter to a not empty condition
>
>Something like: Set filter to not empty(myfield).
>
>But it does not work because this is not the correct syntax.
>
>Is thre anyway to achieve it or set filter is not the solution ?
>
>I tried Set filter to not myfield # "", but it is not the same.
>
>
>Happy New Year to everybody.
>
>Moises

EMPTY() is not Rushmore optimizable unless you add an INDEX ON EMPTY(myfield). That is a non-discriminating index. If you already have another index on myfield like this... INDEX ON UPPER(myfield) TAG xmyfield

then the following will work.

lcSpaces=space(len(myfield))
SET FILTER TO UPPER(myfield) # m.lcSpaces

You won't need a new index and it will optimize.