Find if position 10 trhough 15 are blank in a table

[CD Tom]

This is probably a dumb question but I'm having a hard time figuring it out.
I have a field in a table that has a number in the first 10 positions the rest of the field is blank and I want to delete that record from the table. What's the best way.
Thanks

[isladogs]

Create a delete query similar to this using table & field names as appropriate:

DELETE YourTableName.*
FROM YourTableName
WHERE YourTableName.YourFieldName Is Null;
 

[ADezii]

I may be reading this incorrectly, but the Record to be Deleted has Numbers in positions 1 to 10 and is Blank starting from position 11. Maybe I am just getting old (LOL).

[isladogs]

I'm hoping you are reading it incorrectly.
In any case if a field value has 10 numbers and character 11 onwards are null, the field is 10 characters long!

However, if you are correct, my delete query would be completely wrong!

[ADezii]

I was thinking along the lines that the following Record would not be Deleted. Positions 1 to 10 in the Field are Numeric, but Position 11 on is occupied.

[Field1]
7777777777ABC

Wheras, the following Record would be Deleted since the Field in question has numeric values for the first 10 Positions, but Position 11 is not occupied.

[Field1]
9876523507

I would say go with your instinct, it is probably keener than mine (LOL).

[isladogs]

I assumed the OP meant that the first 10 records had numbers in that field and subsequent records had null values for the field

I guess we'll have to wait and see if the OP returns with the 'correct' meaning.

[ADezii]

In hindsight, my interpretation does seem a little off!

[CD Tom]

Sorry for the confusion. The field will have numbers in the first 5 positions (12345 blank) there are other fields in the table that have numbers in the first 5 positions and then characters (12345 abcdef)
I only want to delete those records with numbers and then blanks.
I hope this is a little clearer.

[isladogs]

First prize goes to adezii!!!!

OK - don't use the DELETE query I gave you earlier!
However, your new description doesn't match the previous one.
Please can you supply several example values and state what you want to happen in each case

[SioSio]

According to post # 8

WHERE LEN(RTRIM(Your_Field_Name)) <= Numeric_digits

[NeoPa]

I've reset Best Answer as it was a good answer in itself - but to a different version of the question.

@CD Tom.
Please try to provide clear questions - with example data being very important if you struggle to express your meaning clearly in words.

PS. My guess, piecing together various of the comments, is that when CD Tom refers to Fields within his table what he actually means is values within different records but of the same Field.