Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
thanks