SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Yes/No/Maybe Data Suggestions
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bholmstrom
Yak Posting Veteran

USA
71 Posts

Posted - 03/12/2013 :  16:25:41  Show Profile  Reply with Quote
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?

Thanks


Bryan Holmstrom

Lamprey
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 03/12/2013 :  20:04:37  Show Profile  Reply with Quote
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"
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000