Mysql convert to Numeric.

Mysql convert string to numeric.

Convert function used to convert string to numeric value.

Syntax:

SELECT CONVERT(column,datatype)

Examples:

SELECT E.CODE, E.EMPNUMBER, 
E.CURADDRESS1 ADDRESS FROM EMPLOYEEMAS E  
LEFT OUTER JOIN CITYMAS C  ON C.CODE = E.CurCityCode
ORDER BY CONVERT(E.EmpNumber,UNSIGNED)

Result: