Null Question

Copper Contributor

Hello Guys, 

i am totally new and just started  SQL 1 weeks age i have come across a problem in SQL

suppose i am working on huge amount of data which is unclean and i want to find NULL & i know the syntax of null but suppose i have almost 50 columns and i want to find out in which row there is NULL is there any we can find NULL or Blank field in this vast data because it will take a lot of time if i just put null syntax and writing one by one column

 

please assist me. thank you

2 Replies
ignore my grammar my English is not that good