>>I'm using a view from an access database, I would like to get rid of all records with a .null. value on a certain field.
>>
>>How do I separate the records with .null. values, I've tried several different >
>Have you used the ISNULL function?
hullo,
let me guess. on that field, the default value is null? is it indexed? can you try 'set order to
descending' so that the records with .null. surface? (will it work, rostand) if so, you can go top, isnull() (hey dan is right) if .t. then delete, and then skip.
just testing... :)
rostand
"le rêve d'étoiles" - (Fr.) the dream of the stars Ü