I am editing a vector layer in ArcMap 10.1 in the attribute table the no data value for some of my fields is -1.7976931348623157e+308. I would like to replace that with 0.
I attempted to use the Find and Replace function in the Table Options using the following settings:
Find what: -1.7976931348623157e+308 Text Match: Whole field Search: Down Match Case: Unticked Search Only Selected Field(s): Ticked Replace with: 0
Clicking either Find Next or Replace All results in an error message:
Search error An invalid SQL statement was used. An invalid SQL statement was used. [Ground_Dissolve2] An invalid SQL statement was used. [SELECT * FROM Ground_Dissolve2 WHERE (htMN = -1.79769313486232e+308)
What does this error message mean and how do I replace -1.7976931348623157e+308 with 0?