Re: testing if value is null

On Mar 31, 10:12 am, laredotornado wrote:
> How do I write a query where if a column, "value," is NULL I return
> the phrase "No value entered" but otherwise return the column's value,
> even if it is the empty string? I'm tried to modify this simple query

You can also use a case statement.

select column1, column2,
value = case when value is null then 'No Value Entered' else value
end,
column4
from meta_data