Not sure how it'll perform (and could depend on your definition of "first"), but:

SELECT COALESCE(

NULLIF([9671], 0),

NULLIF([9672], 0),

NULLIF([9673], 0),

NULLIF([9674], 0),

NULLIF([9781], 0),

NULLIF([9782], 0),

NULLIF([9783], 0),

NULLIF([9784], 0),

NULLIF([9891], 0),

NULLIF([9892], 0),

NULLIF([9893], 0),

NULLIF([9894], 0),

NULLIF([9901], 0),

NULLIF([9902], 0)

)

FROM tbl