Re: Concat two columns in a SELECT with NULL (Access)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Rogas69" <rogas69@xxxxxxxxxxxxxxxx>
Date: Thu, 16 Jun 2005 17:48:12 +0100

Hi Martin

You should check if given field is null - did not read it, but I suppose
concatenation of strings, where one of them is null gives you null?
Use following construct (was in help)

select IIf(IsNull([Firstname]), " ", [Firstname]) ...

Peter

.

Follow-Ups:
- Re: Concat two columns in a SELECT with NULL (Access)
  - From: Martin Roths***

References:
- Concat two columns in a SELECT with NULL (Access)
  - From: Martin Roths***

Prev by Date: Concat two columns in a SELECT with NULL (Access)
Next by Date: Re: A couple of questions about updating data through a dataset
Previous by thread: Concat two columns in a SELECT with NULL (Access)
Next by thread: Re: Concat two columns in a SELECT with NULL (Access)
Index(es):
- Date
- Thread