[dba-VB] [dba-SQLServer] [AccessD] Apples to Oranges

Uhh... I don't know.  But I am guessing it would take me about 11.25 days to write the sql statement.

;)

John W. Colby
www.ColbyConsulting.com

On 10/4/2010 6:39 PM, Stuart McLachlan wrote:
> At 1/2 hour / field, it should only take about 11.25 days :-)
>
> But my question is, do you have to do it a single field at a time? can't you
> update all the fields in a single pass? Something like:
>
> Update mytable set
> field1 = case field1
>                      when " "  then Null
>                      else field1
>               end,
> field2 = case field2
>                      when " "  then Null
>                      else field2
>               end,
> field3 = case field3
>                      when " "  then Null
>                      else field3
>               end,
> ...
>