Re: Bet I can stump the "experts" with this one!!

The fact that you got this error concerns me. You should have never been able to insert the data into the database in the first place, if it is an invalid number. I would start researching on what could possible be wrong to cause such a thing to happen. If it is just a glitch, one way to get rid of the row would be to select * on a field that is not "corrupt". By determining what is in that record, you can delete it by referring not to the corrupted part of the row, but another area, such as another part of the key. Or, if you have SQL*Forms, pull it up on the form and delete. The investigate the heck out of why it happened!!!

-- 
------------------------------------------------------------
My opinions are my own and not that of Huntsville Hospital 
Systems