how to select null values in condition

[jjerryjenson]

i am having four combo boxes.the item in the combo box is taken from the database.we select the data whatever we want and clicking the submit button report want to be displayed.
While selection in the combo boxes, they may select all the fields sometimes they may select one fields and so on.i want to display records according to the selection.to display records i am using jasper i-report.
front end: JSP back end : My SQL
The problem is in the i-report i can write only one query, i cannot check condition sometimes some field may empty or null.

please send me the query so that i can check null values(ie. if the field is null it want to select all the data regarding that field) and select regarding the data.

[sn4rf3r]

SELECT * FROM table WHERE column IS NULL

[jabeen1]

Great one and its solved my problem

[marck_don]

Use the COALESCE function:

COALESCE(Email, 'no email')