Finding exact numbers in a certain position

[richardb]

Is there a way to find a range of numbers in a certain position within a particular record?

I wish to find records that have a number in the first 4 positions of the record, but not records which have numbers in other positions within the record.

Thanks

[markpro]

Call me dense, but are you referring to record or field?

i.e. does a numeric character exist in the first 4 characters of the field contents.

[richardb]

Sorry. Should have made it clearer.

I have data with some records which have a number at the start eg. 443. The rest are text. I wish to find only records which have a number as the start of a particular field and not the text. But the number must be the start of the field, not somewhere else in it.

[markpro]

try creating a calculated field called "Test" the calculation will be:

if(texttonum(left(Your Field,1))>0,"Num","Text")

Where "Num" is the true result of your choice, "Text" is the false result of your choice.

You could also use a Case function instead.

[richardb]

Worked well

thanks kindly