>Hello Group,
>
>I am querying a SQL Server 6.5 table to see if any of the school disticts are of some value
>
>i.e. SELECT * FROM studemo WHERE schdist = 29009.
>
>How would I tell if there were no rows returned?

Assuming that you're using SPT, you can check RECCOUNT() for the cursor returned.