Select Record

I have a file with only one field.

I want the count of records whose 7th Position is '*'. Can some one help.

You can use COUNT(*) WHERE SUBSTR(field,7,1)='*' to get the count. Fill up the rest in the statement.