[Solved] Count the number of existing values in a field in a record [closed]

by


Use CASE expressions to count each column.

SELECT
    CASE WHEN Column1 IS NOT NULL THEN 1 ELSE 0 END
    + CASE WHEN Column2 IS NOT NULL THEN 1 ELSE 0 END
    -- repeat for all columns
    AS NumberOfNonNullColumns
FROM MyTable

3

solved Count the number of existing values in a field in a record [closed]