exclusion help

[#1]

Hi Experts,

i have a table in my qv document which has a field called 'Location code'

the values of Location Code will be like below:

1. 0010

2. 0024

3. 0035

4. 0050

5. PR10

6. OP35

7. IT14, etc..

out of these values, i want to exclude the alphanumeric location codes i.e.,

5. PR10

6. OP35

7. IT14

How can i do this. Please help.

[MK_QSL · Accepted solution]

Data:

Load

  *

Inline

[

  NO, Location Code

  1, 0010

  2, 0024

  3, 0035

  4, 0050

  5, PR10

  6, OP35

  7, IT14

] Where IsNum([Location Code]);

[#3]

thank you so much