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 |
|
bholmstrom
Yak Posting Veteran
76 Posts |
 Posted - 2013-03-12 : 16:25:41
|
| I have a form that has several "Yes/No" fields, and several "Yes/No/Maybe" fields.What would you suggest I build the database fields like to handle these consistently?ThanksBryan Holmstrom |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2013-03-12 : 20:04:37
|
| Create a column of the correct data size like a VARCAHR(5) or CHAR(1) and constrain that column to only accept those values "Yes/No/Maybe" or "Y/N/M" |
 |
|
|
|
|
|
Yes/No/Maybe Data Suggestions