ST Alpha - "depending on the flavor of SQL, an empty appearing cell could not be null" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 161

In response to "Computer / SQL question: Why would something with no value (e.g. '') *not* be Null?" by JaxSean

depending on the flavor of SQL, an empty appearing cell could not be null

Posted by prayformojo (aka mayhem) Nov 19 '09, 11:26

the best way to guard against this is to do something like this:

(if you want to make sure that you're including both fields that actually are null and those that just appear to be empty)

len(ltrim(isnull(fieldname,'')))=0

does that answer your question?

Responses:

Nice, thanks. -- nm - JaxSean Nov 19, 11:29
empty is also something and has a value "0" as an example or "space" -- nm - Danedukenuuk Nov 19, 11:27 2
- uh, not in programming. -- nm - decline Nov 19, 11:28 1
  - no in the evaluation of "data" it has since "null" is a property of "data" -- nm - Danedukenuuk Nov 19, 11:29

Post a message top

depending on the flavor of SQL, an empty appearing cell could not be null

Replies are disabled on threads older than 7 days.