How to use SUM function for NUMC type field?

MySQLDatabasePL/SQL

NUMC is numeric text. As this is text, SUM function cannot be implemented as it is of type varchar in the database.

There is no simple solution to do it. The one method is to copy the data to internal tables, convert the NUMC data into DEC by looping through all the rows, SUM and GROUP them and then convert back the DEC values back to NUMC values.

raja
Updated on 30-Jul-2019 22:30:20

Advertisements