Thanks...that was it-I was actually doing that, but had an error elsewhere
and thought I was doing it wrong! Whew...

Brandon Ludwig
Brandon.Ludwig@M...


 -----Original Message-----
From: 	Brian Kelley [mailto:bkelley@a...] 
Sent:	Sunday, July 15, 2001 12:34 AM
To:	sql language
Subject:	[sql_language] Re: Updating an INT field to NULL

Using UPDATE, here's how:

UPDATE <table name>
SET managerid = NULL
WHERE <search condition>

K. Brian Kelley
Database Administrator/Web Developer
AgFirst Farm Credit Bank

> I have a quick question-it's on the tip of my brain but I can't retrieve 
it
> :)
> 
> I am updating a value into a SQL INT field (managerid), the value will
> either be an INT or NULL. 
> 
> In the UPDATE section-what do I use to set managerid =    to make it a 
null
> value update? 
> 
> Brandon Ludwig
> Brandon.Ludwig@M...