Divide by 0 in a query ?

DivisionName = 'A Division' AND LeagueID = 1 ORDER BY TeamPoints,AvgSpirit But the newly created attribute, AvgSpirit, will fail when a team has not won or lost a game ... Any ideas on how to remedy this problem? Thanks for the help, Camilo Rostoker

Re: SORT problem

5.27 But it should be: 5.10 5.13 5.2 5.2.8 5.3 5.27 Are there any additional parameters you can specify or another method for sorting alphanumeric strings such as this? Thanks for your help, Camilo Rostoker - Before posting

mySQL SORT problem

5.27 But it should be: 5.10 5.13 5.2 5.2.8 5.3 5.27 Are there any additional parameters you can specify or another method for sorting alphanumeric strings such as this? Thanks for your help, Camilo Rostoker - Before

Last Modified function?

Hi. I was wondering if there was a way to find out when the last time the database was modified? (like a last modified function for a webpage?). Thanks for the help. Regards, Camilo Rostoker -- +=+ Camilo Rostoker [EMAIL PROTECTED] http