>In VFP6, following command shows 0 but in VFP9 it show .null.
>How to get 0 in text11 instead of .null. value.
>
>Please help
>

>SELECT AVLBOOK
>INDEX ON GATE_NO TO AVLBOOK1
>SELECT MAX(GATE_NO) AS MAX_GATE_NO FROM AVLBOOK INTO CURSOR V
>THISFORM.TEXT11.VALUE = MAX_GATE_NO
>

I'm not sure the NULL has anything to do with going from 6 to 9. IAC, you can do this...

THISFORM.TEXT11.VALUE = NVL(MAX_GATE_NO, 0)