> You could do this: > > SELECT COUNT(*) from X where memberid < 4567373
That assumes that you are sorting by memberid, of course... Hugh ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------