COUNTIF Equivalent in SQL

[Swegs]

Please excuse me if this is a silly question, but I am from the mainframe world where array processing would solve my problem. I am trying to utilise the equivalent of the Excel =COUNTIF(A1:Z1,"09") statement.

Say I have 26 columns and need to count the occurence of a particular value (in this example 09) in each table row across these 26 columns. In a tool based on SQL2000 how can this be done?

Regards

[Phill Pafford]

SELECT COUNT(field)
FROM table_name
WHERE field = "09" /* if the value is a string */

OR

SELECT COUNT(field)
FROM table_name
WHERE field = 9 /* if the value is numeric */