>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 ??????
You'd use the ISNULL() function, so:
SCAN FOR ! ISNULL(name)
>?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