alter column - NOT NULL

Hi,

Kind of a basic one here. I am trying to change a column so that it has the
property of NOT NULL. How do I do this? I have been able to add the column
to a table, and to set its default value with the ALTER command, but this
one escapes me. If you could provide an example that would be very useful.

Thanks, Tom

_______________________________
Tom Haddon
IT Director
The Better Health Foundation
414 Thirteenth Street, Suite 450
Oakland, CA 94612
(510) 444-5096
www.betterhealthfoundation.org
________________________________