Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-16 : 06:56:50
|
| CajunRider writes "Due to a programming error, I have some records that have NAN recorded in a float field. I now can no longer update or even delete those records. The program now displays "NAN" for the field of the bad records. When I open the table in Enterprise Manager the field shows "-1.#IND". What can I do to fix these records?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-16 : 13:46:55
|
| What happens when you try to delete or update them in Query Analyzer?Tara |
 |
|
|
|
|
|
Recover from NAN error on floating point field