Search the Community
Showing results for tags 'NULL'.
-
I'm working on this session, and it shows if I'd like to test NULL value, I'll need to use below syntax: However, I'd like to know what if I have no idea which column(s) has(have) NULL value? How should I make a query to look for ANY record that includes NULL value without writing specific column_name?
-
hello, I have a table, that contains null in one column. when I query on that table null is also appearing in the result. Is there any option to hide the null? ------------- | id | name | |----------- | | 1 | null | | 2 | BANK | ------------- expected result is: ------------- | id | name | |-------------| | 1 | | | 2 | BANK | -------------
-
Please kindly go tohttp://lifelearning.xtreemhost.com/lib.htmlA testing page. Just check the checkbox "Lib1" and do not enter anything in the input boxI have checked if sFound1 is null in the if condition (already commented in the codes,but the table (at the bottom) still returns the null value. Can anyone help me a bit here?Many thanks in advance.