I have table named as Phone table.
Which has 2 fields Phone number and location code.
There are null values being inserted in these fields. Sometime for either field and sometimes for both fields.
There is file which I think is source of BAD data ( null values),this file is used to update table. But I cannot find any NULL values in the file.
In fact I am not sure how NULL values will appear in the file. How to find NULL ( if any ) in the file.
Possible values in file could be:
2) Some special character
Zeros is not possible in file as they are removed before a insert in the table.
Any ideas..what should I give for " Find command "