Hi Cetin
Sorry for replying late as I was out of town. Thanks for the idea.
>If ansi is off :
>myField = ?cValue && would return all for m.cValue = ''
I had no real experience with characters and I keep ANSI default ie. OFF
>between ?nVal1 and ?nVal2
Actually the requirement arose from numeric
>and put possible lowest/highest values for all.
but do I have to type in these nos. (from the help)
-2147483647 to 2147483647 or there is some shortcut to simulate these numbers something like GOMONTH(DATE(), 1) - 1