Hugo Kornelis (9/4/2010)

---

frodriguez.im (9/4/2010)

---

Now how do you differ an empty or blank field from one with no value? I understand them to be the same.

In a varchar column, the empty value is '' - that is an opening and an ending quote with nothing in between. A great way to represent the middle initial of George Washington, as he had no middle initial.

In the same column, no value would be represented by NULL, the special marker to indicate the absence of a value. A great way to represent the middle intial of the 45th president of the United States, as noone currently knows what (if any!) middle initial he or she has.