>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

Sergey pointed out a slip.

lcSpaces=chr(34)+space(len(myfield))+chr(34)
SET FILTER TO UPPER(myfield) # &lcSpaces.

assuming an INDEX ON UPPER(myfield)....