I am trying to select only the values that are NULL or where there are no values.
Where IsNull(value1, '') = ''
I Also did it like this
Where value1 IS NULL OR value1 = ''
however I do get NULls and empty but I keep getting like 4 values that are not empty they have values in it. Is there another way to do it
SELECT * FROM table1 WHERE value1 IS NULL OR value1 = ''
I get
| value1 | value2 |
|---|---|
| NULL | 3 |
| 5 | |
| NULL | 76 |
| 9 | |
| 3 | |
| 12 | 12 |
| 14 | 6 |
| 8 | |
| NULL | 3 |