Raj,

>
>select count("+col1+") as total;
> from chgnotce where not empty("+col1+") and Deleted() = .f. into cursor temp
>

That will return a count of all records....col1 is not even being evaluated, because it is inside of quotes (a string literal). It would be the same thing as putting empty("SOMETHING") in the query.

See Re: Select statement with count Thread #786834 Message #786849