What's the correct way to deal with Yes\No fields in a database?

[nads]

Always wondered about how yes\no or 0\1 fields should be dealt with in a database.


Should a field which only has a yes\no option, say in Access, be a field in the main table and left as such or should you link the field to a related table?

[steford]

If it's a 1-1 relationship with the "main table" then why not have it as a field? If there is some reason to split it off to another table (can't think of any) then go for it.