I think "" is different than NULL
On Apr 21, 2004, at 11:56 AM, Alan Wolfe wrote:
Hi Ted,
�
We use R:base and can do this:
�
update table set column=''
�
and that sets it to null.
�
have you tried that?
<x-tad-bigger>----- Original Message -----</x-tad-bigger>
<x-tad-bigger> </x-tad-bigger><x-tad-bigger>From:</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>Ted Wolfley</x-tad-bigger><x-tad-bigger> </x-tad-bigger>
<x-tad-bigger>To:</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>[EMAIL PROTECTED]</x-tad-bigger><x-tad-bigger> </x-tad-bigger>
<x-tad-bigger>Sent:</x-tad-bigger><x-tad-bigger> Wednesday, April 21, 2004 11:50 AM</x-tad-bigger>
<x-tad-bigger>Subject:</x-tad-bigger><x-tad-bigger> Witango-Talk: Simple question</x-tad-bigger>
Hi,
�
I would like to put a NULL in a database field with an update action into a SQL Server database but can't figure out how.� Is there a metatag to use?
�
Ted Wolfley
Database/Internet Programmer
The Ogden Group of Rochester
phone: (585) 321 1060 x23
fax: (585) 321 0043
[EMAIL PROTECTED]
www.ogdengroup.com
�
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
