Discussion Locked

Access 2000 Delete Select Record

0 helpful

4 replies

by devmann Apr 27, 2006 last reply Apr 27, 2006 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a table where a field is Text format.
The values in the field can be numbers and text.
How would I delete only records that have a text value.

4 replies

That's going to be a pain.

might help

you could also try the like operator

Delete from mytable where mytextfield not like '*[012346789]*' might do the job

This would get rid of all rows which don't have a digit somewhere in them.

use select first or make a back up.

P.S. if you use floating points or signed numbers in there you need to deal with -(+) and . as well.

oops wrong wild card

Delete from mytable where mytextfield not like '%[012346789]%' might do the job

Thanks for the solution, it helped me a great deal....

This question was closed by the author

This discussion is closed to new replies.