hi all,
i wantto use this value in my query forms, via between command , i know that 0x7FFFFFFF value using with integer fields . Is it possible to use this value for char fields or which method can be use instead of this value for catch max value for this char fiels

TIA

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