How to use NVL function in SQL query in mendix.

SELECT Date_Of_Birth AS DOB, Country as Country from Details where Gender='Male' and zipcode = 'XXXXXX'   In microflow Execute query is implemented and the query above is getting used.   Problem statement For some records the Date_of_Birth is having null/empty value, due to this reason the Execute query never getting executed. Is there any way I can use NVL function in this query to make it work.   Thanks, Sudhansu
0 answers