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 |
|
matta0990
Starting Member
44 Posts |
 Posted - 2011-04-20 : 08:28:06
|
| Hi, I've created a table called "Customer" and i've added the coloum "Title" but i want to limit the users input into that coloum to (Mr, Mrs, Miss etc....) how to i do this?Im using SQL Server Management Studio 2008.Thanks, MattM Atkinson |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-04-20 : 08:33:01
|
What are the users using to input data in that table?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
matta0990
Starting Member
44 Posts |
Posted - 2011-04-20 : 08:39:02
|
| Well it would be a drop down box or summit. But for this i want an error to come up if anything other than (Mr, Mrs, Miss etc..) is entered into the field.Is is possible??M Atkinson |
|
|
|
|
|
|
How to set specific values in SQL table columns?