Forum Discussion
Null Question
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
- ignore my grammar my English is not that good
- This SO answer has a pretty clever idea for this: https://stackoverflow.com/questions/14488859/find-all-rows-with-null-values-in-any-column
