sql - Counting rows in the table which have 1 or more missing values - Stack Overflow

PHOTO EMBED

Fri Feb 18 2022 03:17:48 GMT+0000 (UTC)

Saved by @Bambibo9799 #sql

Select Count(*)
From   mySchema.myTable
Where  Cast(Col1 As NVarChar(128)) +
       Cast(Col2 As NVarChar(128)) +
       Cast(Coln As NVarChar(128)) Like '%?%'
content_copyCOPY

https://stackoverflow.com/questions/32651363/counting-rows-in-the-table-which-have-1-or-more-missing-values