That is what I mean. I do not agree that the SQL Select command is smarter than the IF command. The following command will not call function1 unless field1 = "Test" - with or without an index:

IF field1 = "Test" and function1()

>That's probably what he means.
>
>But in one way the SELECT statement is a little smarter...if there is an index on field1, this code will not call function1() for every record in the table.
>
>

>select * from table1 where function1() and field1 = "Test"
>

>
>>
>>This is what he means, I think:
>>
>>

IF .F. AND DontEval()
>>	? "Don't print"
>>ENDIF
>>
>>FUNCTION DontEval
>>	? "Don't Print"
>>ENDif