How to use the sum function of SQL to calculate sum of varchar field. I'm looking for a solution where we cannot use count.
+2
A:
If the varchar field contains strings that can be interpreted as numbers:
select sum(to_number(the_column)) from the_table
If not, I do not understand the question.
Thilo
2010-10-05 05:23:33