Versuch's mal so:

Code:
Select  Case When ABS01 <> 1 Then 1 Else 0 End +
        Case when ABS02 <> 1 Then 1 Else 0 End +
         ....
        Case When ABSN <> 1 then 1 Else 0 End AnzSpalten
From YourTable
Birgitta