Leo_Polla_Psemata
Registered User.
- Local time
- Today, 09:43
- Joined
- Mar 24, 2014
- Messages
- 364
Hi
I have a field, say ALFA, field size 3, type of value is text but some text contains 3 digits which i don't need to calculate so ALFA is text.
I would like to make a query that filters these records where ALFA does have ONLY letters, not diggits.
Example
Record1, ALFA = ABC
Record2, ALFA = 123
Record3, ALFA = DEF
Record4, ALFA = 456
I need a criteria that will fetch only the Record1 and Record3.
Do you have any good idea ?
I have a field, say ALFA, field size 3, type of value is text but some text contains 3 digits which i don't need to calculate so ALFA is text.
I would like to make a query that filters these records where ALFA does have ONLY letters, not diggits.
Example
Record1, ALFA = ABC
Record2, ALFA = 123
Record3, ALFA = DEF
Record4, ALFA = 456
I need a criteria that will fetch only the Record1 and Record3.
Do you have any good idea ?