That's my understanding of [] also, but I don't think they hurt (in most cases) if used when not needed And I was tring any veriation I could think of.
Nope it don't like Modify either. ALTER TABLE [dbo].[Contact_tbl] MODIFY [FirstName] SET DEFAULT 'dddddd' GETS: Msg 102, Level 15, State 1, Procedure SPTemp, Line 8 Incorrect syntax near the keyword 'FirstName'. ALTER TABLE [dbo].[Contact_tbl] MODIFY FirstName SET DEFAULT 'dddddd' GETS: Msg 102, Level 15, State 1, Procedure SPTemp, Line 8 Incorrect syntax near the keyword 'MODIFY'. So there the [] make a difference, just not sure what or why. Thanks for the suggestion. Rodney -----Original Message----- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Thursday, August 30, 2007 3:01 PM To: SQL Subject: Re: Alter column problem Aren't the [brackets] just for when names have spaces or are keywords? Anyway, the syntax looks okay against that example... maybe try something like this: ALTER TABLE Contact_tbl MODIFY FirstName VARCHAR(50) DEFAULT 'dddddd' ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2934 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
