I already did that and there are no nulls. -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 4:42 PM To: SQL Subject: Re: Alter Table Problem
What do you get when you run: SELECT * FROM tblCurrentCouncilMembers WHERE Member_ID IS NULL If it returns anything, then you need to take care of those NULLs before running the ALTER. user=26053.18869.6 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2808 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
