>I'm looking to count the number of incidents various ranges of months.
>
>Can the following query be done without the second procedural step -- purely in SQL?
>
>

>*******************************
>PROCEDURE GetViosInRange
>*******************************
>LPARAMETERS tcVioCat,tnLowMonths,tnHiMonths,tnLowBound,tnHiBound
>LOCAL lnRetVal
>SELECT * FROM WCDRVA ;
>WHERE mvrcat = tcVioCat ;
>AND BETWEEN(monthsago,tnLowMonths,tnHiMonths) ;
>AND drvseq = this.drivernum;
>INTO cursor thesevios
>lnRetVal = 0
>IF tnlowbound > 0
>   SKIP tnlowbound-1
>   SCAN WHILE RECNO() <= tnhibound
>     lnretval = lnretval + 1
>   ENDSCAN
>endi
>RETURN lnRetVal
>

Can you post some example data and what you want as a result from it?