thanks for that Ed.
yes u r correct .we can use an id field. in this case we dont any id field in the tables having blank records so i need to check each field in the row beore calling it as a blank record. i thought there would be better way finding such type of blank records.