Query SQL -- help !!!

Hi, the next query returns 11 coloumns with null and string value.

SELECT (SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=1')) AS Rule1,
(SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=2')) AS Rule2,
(SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=3')) AS Rule3,
(SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=4')) AS Rule4,
(SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=5')) AS Rule5,
(SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=6')) AS Rule6,
(SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=7')) AS Rule7,
(SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=8')) AS Rule8,
(SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=9')) AS Rule9,
(SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=10')) AS Rule10,
(SELECT [85.32.201.81].MessageText
WHERE ([85.32.201.81].MessageText LIKE '%Rule=11')) AS Rule11
FROM [85.32.201.81]
WHERE (MessageText LIKE '%Rule=%')

The question is how to count the number of entries of each coloumn ??

I want something like this:

Rule1 Rule2 Rule3 ...... Rule11
7 25 2 57


Thanks a lot

Stefano