Hi Gan,

Check out the ISNULL() function.

The syntax might be something like
SCAN FOR !ISNULL( cName )
(assuming that cName is the name of the field holding the data)

HTH,
Evan Pauley


>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