Query for Numbers

[Tim Fields]

Hallo!

In my table are the following entries:

A1
B1
B100
B2
B24
B8724
BA1
B99999999
C19AB1
.....

I like to get all entries beginning with B and a following number. The
syntay "LIKE "B#" or "LIKE [0-9] does not work, because the amount of
numbers behind the B can vary.

Thanks in advance

Tim

 

[Ken Snell [MVP]]

Like "B[0-9]*"

 

[Tim Fields]

Thanks for your answer, I think, my question was not clear.

Like "B[0-9]*" returns B12, B34 but also B3A. I need all strings beginning
with B and only following numbers.

Tim

 

[Ken Snell [MVP]]

WHERE Left(FieldName, 1)="B" And IsNumeric(Mid(FieldName, 2)) = True

 

[Tim Fields]

Thanks for your help, it works very fine.

Tim