Experts:
I need assistance with developing a query to identify records that do NOT include a 10-digit number.
Background:
- I have a data set with nearly 70,000 records.
- One field is called "DOD_ID"... any valid record includes a 10-digt number (e.g., 1234567890).
- However, there are a few records that look as follows:
1. Alpha-numeric values:
- Example #1: "62C4839456"
- Example #2: "123456789X"
... both records include a non-numeric value somewhere in the string.
2. Numeric values less than 10 characters:
- Example #1: "123456789"
- Example #2: "12345678"
... both records are less than 10 characters in length and thus are "invalid".
My question:
What SQL query would allow me to identify any records which either 1) are alpha-numeric or b) are < 10 characters in length? Ideally, I'd like to use a single query (vs. 2 queries).
Thank you,
Tom