APEX

Hi,

I have a field "Priority" which is an optional field in my application. The possible values are 1. Low, 2. Medium 3.High and 4. NULL (database null value).

For this,
I have created a static LOV with 3 values (low, medium and high).
And when using this LOV, I have mentioned "Display Null" as Yes and NULL Display Value as "-NA-". I have left the "Null Return Value" field blank.

but when I select "-NA-" from the LOV from front end, The return value is "%null%". I want the return value to be null as in database null value.

I have tried using "Null Return Value" as "NULL". but it just returns the string "NULL".

How do I do it?

Thanks in advance.
Ketan