filtering within the middle of the number 1

[Monkey820]

Hi There!
How can I filter numbers within the middle of the value?

for example:

I have these numbers:

7009-11001
7009-01001
7012-10002
7012-01003
2569-01004
2569-11001

I need to filter out only the numbers that the 6th character is greater than "0". Only the 6th character should be considered in the filter.

TIA,
Micky

Crystal Reports 8.5

 

[Ngolem]

If it is a number try this in a record selection formula


{Table.numberString}[6] = "0"

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[Monkey820]

PERFECT!!
Thank you very much!
Micky