SQLite, check if TEXT field has any alphabetical chars in it

You can use GLOB in SQLite with a range to single them out:

SELECT * FROM MY_TABLEWHERE num GLOB '*[A-Za-z]*'

For example, for these records:

   num----------1234567890098765432110000000001000A000001000B000001000c00000

GLOB '*[A-Za-z]*' will return these three:

   num----------1000A000001000B000001000c00000

You can then translate that to the appropriate DELETE:

DELETE FROM MY_TABLEWHERE num GLOB '*[A-Za-z]*'

CodeHunter