Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Going_craazy
Starting Member
9 Posts |
 Posted - 2008-06-27 : 14:53:22
|
| Hi,I am trying to add a check constraint to the column "State" to ensure that the state is CA, UT, AZ, WY, OR, or WA. Table name is customer. I tried State LIKE ('CA', 'UT', 'AR', 'WY','WA')I am getting an error "- Unable to add constraint 'ValidState'. Incorrect syntax near ','.I tried State LIKE ('CA', 'UT', 'AR', 'WY','WA')Can anybody help me. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Going_craazy
Starting Member
9 Posts |
Posted - 2008-06-27 : 15:03:13
|
| Hi,Thank you for the reply.Can you tell me any online source for syntax for building expressions in SQL. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
Going_craazy
Starting Member
9 Posts |
Posted - 2008-06-27 : 15:11:28
|
Thank you. |
|
|
|
|
|
|
|
|
Check Constraint Question