>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?
>
>Thanks
>Jim
In Visual FoxPro, usually I would use the _tally variable, that returns the number of records processed. I am not sure whether this works in C/S.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)