Re: Replace Null

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Alec MacLean (alec.maclean_at_NO-SPAM-copeohs.com)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 15:50:41 +0100

Try something along these lines:

SELECT Value1, value2, ISNULL(Value3, "-") FROM <source_table>...

In this example, the ISNULL function will replace any instance of a NULL in
column "Value3" with "-".

Al

"Manny Chohan" <MannyChohan@discussions.microsoft.com> wrote in message
news:8FCA7EB5-5F75-46F2-944A-AD91D5F884C6@microsoft.com...
> How can i replace Null with a blank field in the select query?
>
> Manny

Relevant Pages

  • Re: Need to identify an empty field
    ... In a query you would use Is Null as criteria. ... In VBA you would use the IsNull function. ...
    (microsoft.public.access.queries)
  • Re: Records with null contents fail query
    ... The IsNull function you've posted is the SQL Server version, ... >>I created a query to exclude certain records ... >>This query excluded all records which contained the text ... >>Field1, ...
    (microsoft.public.access.queries)
  • RE: Help!! I having problems with Null Values!
    ... Perhaps you need to use the conditional IF function, IIF, in combination ... The syntax for the IsNull function is this: ... using the Customers table in a query: ...
    (microsoft.public.access.gettingstarted)
  • Re: Help with php to MySql...
    ... echo "POST"; ... Then add an "or die" statement to the end of your query - something ...
    (comp.lang.php)
  • Re: Another problem w/ NULL values in XML
    ... Jonathan Chong wrote: ... This worked fine until the query actually encountered actual ... > Have you try using IsNull function? ... Zach ...
    (microsoft.public.sqlserver.programming)