repeatative digits

[mah_1356]

hi

I have a field that contain numeric value
I want to filter the data that have 9 digit or lower or have repeative digits such as 1111 or 22222
thanks

[prieper]

As this is more a text-analysis would
1. convert the number into a text (TEXT()-funtion), e.g. TEXT(Field) AS MyField
2. Filter this text then with the LEN()-function. e.g. LEN(MyField) < 9
3. Filter this text then with WILDMATCH()-function, e.g. WILDMATCH(MyField, '1111*', '22222*')

HTH
Peter

[mah_1356]

thanks