>Hey Everyone,
>I am trying to perform a command like :
>If not Exists(select field from database where anotherfield = this)
>
>Does Foxpro have an exists command that would allow me do this? I keep getting a "Function Name is Missing" error. Am I doing this wrong? Should I be using another command to perform this? Any help would be appreciated. Thanks.

Try

SELECT field from database where anotherfield = this
IF _TALLY = 0 && there are no results from query
* do something
ENDIF