>Hi everybody,
>
>If I want to filter all non-empty values for character (100) field, what would be the best expression for the index (if I need the index)?
>
>Thanks in advance.
I don't know if this is a best solution:
INDEX ON MyField FOR !EMPTY(MyField) TAG TableTag
SET ORDER TO TableTag
BROW
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.