I have a table with 5 records with record #3 having a .null. value in it. How can I scan the table without .null records?
Eg.
mytable
name :scott, mike, .null., toni, amy
scan for ??????
?name
endscan
result: scott, mike, toni, amy
What would be the correct syntax for me to use on the SCAN FOR????
I would GREATLY appreciate for any helps I can get.
Thanks
Scott McDaniel
MCP VFP Desktop