Executing a select statement will return the number of rows found and set the in memory active list of keys which can be accessed using a list statement.
@ID contains the name of the record key, use this field in you comparison criteria.
SELECT INVENTORY WITH @ID GT 100 AND @ID LT 200
@ID contains the name of the record key, use this field in you comparison criteria. For example find all window source code belonging to the EXAMPLES app. The right bracket operator means 'beginning with'.