Daren,

If the fields are character fields, I've seen instances where CRs and LFs got mixed in with the data. They'll show up like the black bars |. I think any non-printing character will show up that way..

You could try the following to weed them out.

SELECT * from yourtabel WHERE CHR(13)$chrfield OR CHR(10)$chrfield

If the whole record isn't hosed, you sometimes can strip out the bars if you can figure out what CHR() value they represent.

REPLACE ALL badfield WITH STRTRAN(badfield,CHR(13),"")

HTH

- Brian


>I've had a few user's experience corupt records within several tables do to a server crash, power outage, etc.
>
>Is there a way to detect/delete corupt records? The records read like bar code but as far as I can tell, I can't query them out (delete-sql). I found I can do an export to excel sheet, clean the table and re-import the data. The bad records don't get exported. However, this seems to take a long time. Anyone have a better method?
>
>Thanks in Advance!
>Daren Hopper