Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null
Message
 
To
04/06/2009 12:33:21
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Null
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01403676
Message ID:
01403723
Views:
43
>>For what it's worth, I only use NULLs (when I have a say in the matter) when NULL has business significance (i.e. a user left a survey question or some other column blank).
>>
>>If there is no business need to differentiate between a NULL and an empty string, my personal vote is for empty string.
>
>Sorry, I may be misunderstanding, but "(i.e. a user left a survey question or some other column blank)" seems to contrast with "If there is no business need to differentiate between a NULL and an empty string, my personal vote is for empty string". Unless you consider the user leaving a survey question blank as a business need. Was the field required or optional? If it was optional, it makes sense to leave it blank. If it was required and not filled out (and validation let it pass) then it makes sense to make it NULL because there's a business need to act on that later.
>
>Are we saying the same thing but in different ways?

It sounds that way to me..
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform