Converting a charcter string to numeric in SQL in FOXPRO for UNIX 2.6 1

[dquintard]

I need to know the correct syntax for SQL I am writing. I need to convert a column in a table that is a charcter to numeric and then sum the values of that column.

 

[DSummZZZ]

Try something like:

SELECT SUM(VAL(MyField)) AS HowMuch FROM MyTable .....
Dave S.