[AccessD] Null to empty strings

Or you could update the Field to NZ(Field,"")

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Eoin C. Bairéad
> Sent: 27 October 2005 00:27
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Null to empty strings
> 
> 
> If you mean empty string rather than blank then you need
> 1 tell the table that the field in question CAN be zero 
> length (the default is it can't) and 2 use "" rather than " " 
> in the examples.
> 
> 
> 
> On 27/10/05, John Ruff <papparuff at comcast.net> wrote:
> >
> > Create an update query and in the Update To row of the field to 
> > update,
> > use:
> >
> > Iif(isnull(FieldToChange)," ")
> >
> > MAKE SURE YOU MAKE A COPY OF YOUR TABLE FIRST!!!
> >
> > John V. Ruff - The Eternal Optimist :-)
> >
> > "Commit to the Lord whatever you do,
> > and your plans will succeed." Proverbs 16:3
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
> > Sent: Wednesday, October 26, 2005 2:45 PM
> > To: 'Accessd (E-mail)
> > Subject: [AccessD] Null to empty strings
> >
> > What is the easiest way to convert all null values in a 
> table to empty 
> > strings? This is a one time conversion. TIA Jim Hale
> >
>