get numbers only question
I tried this:
SELECT employee_number FROM employees WHERE employee_number REGEXP ('[0-9]');
it's working excellent and I getting these numbers
7, 8, 9, 11, 1.222, 12, 13, 9, 15, 9, 9, 9
BUT....
when I run:
SELECT MAX(employee_number) FROM employees WHERE employee_number REGEXP ('[0-9]');
I get 9 where i should get 15.
why is that?
Subject
Written By
Posted
get numbers only question
July 20, 2014 02:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.