I have a field which can holds string values which are alphanumeric. I would like to filter the field so that I return only the alpha rows.
Table = Customer
Field = AcctNum
Suppose that these are the rows:
AcctNum
123456
ABC
ZTL
G23456
9955AC
By doing the following query:
Select * from customer where AcctNum between 'A' and 'Z'
returns ABC,ZTL and of course G23456,9955AC
How can I refine the query so that it returns only ABC and ZTL?
Thanks in advance
Table = Customer
Field = AcctNum
Suppose that these are the rows:
AcctNum
123456
ABC
ZTL
G23456
9955AC
By doing the following query:
Select * from customer where AcctNum between 'A' and 'Z'
returns ABC,ZTL and of course G23456,9955AC
How can I refine the query so that it returns only ABC and ZTL?
Thanks in advance