View previous topic :: View next topic
|
Author |
Message |
ashishsr123
New User
Joined: 06 May 2008 Posts: 33 Location: Chennai
|
|
|
|
Hi,
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:
1) Spaces
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 " |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
There is no such thing as a "null value". Every value from x'00' to x'FF' is a "real" value. Null is the absense of a value and can only be recognized by some indicator.
Look at the file using HEX ON. You should quickly be able to see questionable values in the data.
You might also use the FIND P'.' command. |
|
Back to top |
|
|
|