[solved] AVG() in mssql vs AVG() in mysql
Posted: Thu Jul 08, 2004 11:37 am
I've just converted a mysql DB to mssql and use the AVG aggregate function on a field..
where mysql would give me results using AVG on a text field..
msql requires a numeric field type...
problem is.. i'm storing text and numeric data in this field..
i'm only averaging the numeric data.. but it still needs to have text data in there
anyone know of an alternate field type or will i have to write lots of code to fix this.. or redesign my database .. (eeek)
any help is greatly apprecitated..
Thanks
ws
where mysql would give me results using AVG on a text field..
msql requires a numeric field type...
problem is.. i'm storing text and numeric data in this field..
i'm only averaging the numeric data.. but it still needs to have text data in there
anyone know of an alternate field type or will i have to write lots of code to fix this.. or redesign my database .. (eeek)
any help is greatly apprecitated..
Thanks
ws