I am using criteria query in SQL for below condition
Select col1,col2 where not(col1='close')
Now the issue, when col1 having any 'NULLl values , query is not returning any data.
Please help me for handling this condition.
Thanks & Regards,
Ayyappa Kolli.