>I have not used EVL() at all - it seems to be just a substitution for something like:
>
>
>lnResult = IIF(EMPTY(tnParameter),0,tnParameter)
>
>
>Is this all it is useful for? Always trying to learn something new...
>
>Also, help notes do not suggest what EVL stand for - "Empty Value test" maybe?
Yes, it's analogous to NVL() and I've been known to nest them to ensure that I get a value that's both non-empty and non-null. I assume EVL() stands for "empty value" (though I prefer to read it as "evil" ;-) ).
Tamar