Ok what do I have to do to make it work if JUST checking for NULL columns it
is ok to update field?
I have ACCESS database.

I was given this but I cannot make it work:

UPDATE Table
SET Col1 = ISNULL(NULLIF(Col1,''),'new value'),
Col2 = ISNULL(NULLIF(Col2,''),'new value')

Please help!~

Try just :

UPDATE MyTable SET Col1 ='new value' WHERE Col1 IS NULL

--
Patrice

"DanjoMan" <DanjoMan [at] discussions.microsoft.com> a écrit dans le message de
news: 7B1AA7D4-6450-4532-910D-9A9750D5B6FC [at] microsoft.com...
> Ok what do I have to do to make it work if JUST checking for NULL columns
> it
> is ok to update field?
> I have ACCESS database.
>
> I was given this but I cannot make it work:
>
> UPDATE Table
> SET Col1 = ISNULL(NULLIF(Col1,''),'new value'),
> Col2 = ISNULL(NULLIF(Col2,''),'new value')
>
> Please help!~