Drop Table specific "types"

[#1]

Hello again,

i have 1 Question and i hope you can help me.

I have a table with prices for different groups, Meaning:

Artikl Cjenik Cijena

1x1     A         10

1x1     D          8

1x1     2580     8

1x1     111106  8

I. Question/Problem:

The column "Cjenik" has A,D,M,T and some numbers(around 20000 different numbers). I want that every number with less then 6 Figures is dropped from the table, but the Letters should also stay. Can somebody please tell me the formula, if there is any?

Thank you very much in advance.

greetings,

Kristian

[Nicole-Smith]

Use the WHERE clause:

WHERE IsNum(CjenikTemp) = 0 OR (IsNum(CjenikTemp) = -1 AND CjenikTemp > 99999);

IsNum(CjenikTemp) = 0 says if it is not a number (i.e. if it is text/letters) keep it

OR

IsNum(CjenikTemp) = -1 AND CjenikTemp > 99999 says if it is a number and it is greater than 99999 (if it is 6 digits) then keep it

(Example is attached.)