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
Published on 08-Feb-2018 10:24:39
Advertisements