Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.)