Re: General SQL question

update mytable set colA = colB

   WHERE colB IS NOT null and

Allen <Allen_Brost-FAB101_at_email.mot.com> сообщил в новостях следующее:38BE83CC.5E927839_at_email.mot.com...
> Having some problems with syntax, maybe someone out there can help.
> I want to copy one column of a table to another column within the same
> table. The only criteria is that I do not want to copy the columns that
are
> null.
>
> update mytable set colA = colB
> WHERE colB != null and
>
>
> I keep getting 0 rows updated. What is the correct way to do this.
>
> Thanks.
>
Received on Fri Mar 10 2000 - 06:39:59 CST