InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 05:24:41 GMT20http://www.sqlservercentral.com/Forums/Topic481464-146-1.aspxPlease post new questions in a new thread. Thanks.Sun, 27 Jun 2010 23:36:30 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic481464-146-1.aspxhello, I'm a beginner in SQL Server 2005, i'm trying to create[b] check constraint[/b], and when i'm trying to create it, an error message was appear. my steps are:1) The field is ZIP using nchar(5), 2) in the [b]Expression[/b] I type: zip LIKE '[0-9][0-9][0-9][0-9][0-9]'3) When I click Save button, there was an error message and unable to save the changeskindly help...Sun, 27 Jun 2010 20:15:40 GMTmarina.x.rotuahttp://www.sqlservercentral.com/Forums/Topic481464-146-1.aspxdon't believe everything you read.Tue, 08 Apr 2008 07:03:38 GMTMichael Earl-395764http://www.sqlservercentral.com/Forums/Topic481464-146-1.aspxRemove @ from your statement( [b]@[/b]State In('CA', 'UT', 'AZ', 'WY'))Tue, 08 Apr 2008 07:03:19 GMTzgembohttp://www.sqlservercentral.com/Forums/Topic481464-146-1.aspxThank you so much Michael,The book does specify the @ but it is incorrect! Thank you again. I will remember.DanielTue, 08 Apr 2008 06:59:06 GMTdaniel-703741http://www.sqlservercentral.com/Forums/Topic481464-146-1.aspxRemove the @ symbolState In('CA', 'UT', 'AZ', 'WY')"State" is referring to your field name.Tue, 08 Apr 2008 06:50:08 GMTMichael Earl-395764http://www.sqlservercentral.com/Forums/Topic481464-146-1.aspxHello. I am obviously very new to SQL Server 2005 Express. I am an Access developer and I am giving a try to SQL Server Express. Maybe my question will be answered faster this way 8)I am going through a book (... In 24 Hours series) and every time I try to complete a simple exercise about creating a (seems like a) Check Constraint I get an error. Here's what I am doing:The field is [b]State[/b]: Char (2) and we want to apply the constraint where only the following values are accepted: CA, UT, AZ WY, and a few others.My steps:I click the selected to the left of the [b]State [/b]field and click [b]Manage Check Constraints[/b].In the Check Constraint dialog I click [b]Add [/b]and the constraint CK_Table_1* appears. The name is simply CK_Table_1.I name the constraint ckState (like in the book)In the [b]Expression [/b]I type @State In('CA', 'UT', 'AZ', 'WY') and as soon as I hit Enter a message appears that there is an error in the constraint and ask me if I want to Edit it.I am at loss here because this matches the screen shot in the book.Can anyone help?I hope I provided enough information.Tue, 08 Apr 2008 06:17:32 GMTdaniel-703741