lcMaxCustID=iif(empty(.text2.value, REPLICATE(CHR(255), LEN(customers.custid)),.text2.value)>hi all,
>with thisform >lcMinCustID=min(.text1.value,.text2.value) >lcMaxCustID=Max(.text1.value,.text2.value) >lcMaxCustID=iif(empty(.text2.value,0x7FFFFFFF,.text2.value) >endwith >... > >select * from customers where custid between lcminCustID and lcmaxCustID into cursor CrsCustomers > > >