[AccessD] Null to empty strings

If you mean empty string rather than blank then you need
1

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
>
> ***********************************************************************
> The information transmitted is intended solely for the individual or
> entity to which it is addressed and may contain confidential and/or
> privileged material. Any review, retransmission, dissemination or
> other use of or taking action in reliance upon this information by
> persons or entities other than the intended recipient is prohibited.
> If you have received this email in error please contact the sender and
> delete the material from any computer. As a recipient of this email,
> you are responsible for screening its contents and the contents of any
> attachments for the presence of viruses. No liability is accepted for
> any damages caused by any virus transmitted by this email.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



--
--
Eoin C. Bairéad
Dublin, Ireland
Áth Cliath, Éire