WHERE t1.vnd_id > 1 * note that the 1 is not quoted above - quoting turns it into a character string- if t1.vnd_id is actually character, your code doesn't give a syntax error but it might not be doing what you would expect. In that case you need to left-pad both the field contents and your comparison string with either zeroes or spaces. Suppose t1.vnd_id is C( 4 ):
* in the Command window: ? "2" > "1" && .T. ? "2" > "12" && .T. ? "0002" > "0012" && .F. ? " 2" > " 12" && .F.