MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

how to select numbers (integers) only?
Posted by: Jassm Rahma
Date: July 17, 2014 02:52AM

Hi,

I have employee_number field which has employee_numbers like this:

12
434
ABC345
QWR-567

I want to know how can I just select the numeric values to perform a MAX on it?

so ABC345 and QWR-567 will not be considered in the SELECT

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
how to select numbers (integers) only?
Jassm Rahma
July 17, 2014 02:52AM
Re: how to select numbers (integers) only?
Phillip Ward
July 17, 2014 06:17AM


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.