Query Criteria - text only

[Leo_Polla_Psemata]

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 ?

 

[bob fitz]

Try:

SELECT Table1.ALFA
FROM Table1
WHERE (((IsNumeric([ALFA]))<>True));

You will need to replace "Table1" with the Name of your table.

 

[theDBguy]

Hi. Would it be possible to have a mixture of both alpha and numeric digits?

A21
34B
etc.

 

[bob fitz]

Hi. Would it be possible to have a mixture of both alpha and numeric digits?

A21
34B
etc.

If it would be possible, just change the WHERE statement to:

WHERE (((IsNumeric([ALFA]))=False));

 

[Leo_Polla_Psemata]

Many thanks
This
WHERE (((IsNumeric([ALFA]))=False));
and this
WHERE (((IsNumeric([ALFA]))<>True));
have solved my puzzle of the day.



About this
A21
34B
So far i haven't met such case, believe the "numeric false" will remove it.

 

[theDBguy]

Hi. Glad to hear you got it sorted out. Good luck with your project.

 

[Deleted member 147267]

Either of these would also work if it's your style (I probably think more along these lines)

SELECT FieldName FROM tblName WHERE Isnumeric([FieldName]);

SELECT FieldName FROM tblName WHERE Not Isnumeric([FieldName]);