! if the file has a key of KEY1$:KEY2$:KEY3$
! and you want to get everything where Key1$ is a specific key
! and the rest do not matter
SELECT *,REC=Record$ FROM FileChannel BEGIN KEY1$:$$:$$ END KEY1$:$FF$:$FF$
NEXT RECORD
! If you use key1$+$$ and key1$+$FF$ you will end up selecting all records
! that BEGIN with that key rather than EQUAL to that key
! using key1$+$$ etc will cause issues when the data in the key does not
! completely fill the maximum Length of the key (such as Item Codes)