What is the difference between a character field that contains a null value and a character field that contains a single blank space?

QUESTION:

What is the difference between a character field that contains a null value and a character field that contains a single blank space?

 

[signinlocker]

SOLUTION

 

A character field that contains a null value is zero characters long, while a character field that contains a single blank space has a length of one character.

[/signinlocker]

Leave a Reply

Your email address will not be published. Required fields are marked *