lcMaxCustID=iif(empty(.text2.value, REPLICATE(CHR(255), LEN(customers.custid)),.text2.value)

>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
>
>
>