[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
>

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