I have written the following query and even though I used CAST if the
number is less then 1 it show up as 0. Here is the query:
select cast(count(SafetyTrainingYN) AS FLOAT)
from ICPCDATA
where SafetyTrainingYN = 1 /
(select count(SafetyTrainingYN)
from ICPCDATA)
Any help would be much appreciated.
Thanks,
jp
remove _nospam_ for my email
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!