Hi List.
I am returning the average with the following statement in asp.
"SELECT AVG(data_enjoy) as q1m FROM 2005_Party;"
The problem is that my results are being returned as an integer and is
not displaying the actual answer which containd decimals.
I've tried using the following but that gave me an error.
"SELECT AVG(CAST(data_enjoy as decimal(5,4))) as q1m FROM 2005_Party;"
Any ideas?
My DB value are set up as integers
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
