Actually I wanted something like

SELECT tNo, COUNT(tField > 0) AS POSITIVE,COUNT(tField < 0) AS NEGATIVE,
COUNT(tField = 0) AS ZEROES (...etc)
FROM table
GROUP BY tNo

Regards

Radu