sql2000:

Code:
select table1.field1, table1.field2, case when table1.field5 = 10 then '10'
when table.field5 = 11 then '11' end as result, table1.field6
from table1
is it possible to count number of times when result is '10'?.