testing if value is null

Hi,

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

SELECT value FROM meta_data

Thanks, - Dave
.

Relevant Pages

  • Re: Can I query using 2 *
    ... Is it possible to make a query using 2 partial names in the field name to ... *Parenting*(for Modern Day Parenting, Good Parenting Skills, Parenting a ... Teenager, etc), so I get all 6 Book Titles? ... To find the phrase only at the beginning of the field: ...
    (microsoft.public.access.queries)
  • Re: Browsing the linux code
    ... 13 Sep 2005 20:35 UTC, Generic Usenet Account typed: ... > My query has been misinterpreted ... you did phrase it clearly. ...
    (comp.os.linux.misc)
  • Re: Quoted literal strings wont force a phrase match
    ... ignoring noise words in my phrase match. ... My impression was that noise words aren't stripped out of a full text ... search if the search phrase is a quoted literal. ... Here is the query that I'm using: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: searching in these forums - help!
    ... Your query for "error" did not return results. ... Check your spelling. ... Enter a term or phrase that's less specific. ... Try different phrasing. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Select query: retrieve specific terms only when followed by a spac
    ... > I am trying to create a select query that will retrieve my specific text ... The above will find the phrase if it is at the beginning of the field. ... Prev by Date: ...
    (microsoft.public.access.queries)