Is NULL value treated as a blank or 0.????

Hi,
I think null is not a blank also, null is null nothing else like no value as per my knowledge.

i'll Check and update you soon Rajini

hi,
Null value is a Blank..

Blank is Empty String
Null is No Value

When a field is specified as UNIQUE, there can be multiple records with NO VALUE (i.e. NULL) in that field, but of course there cannot be multiple records with the SAME VALUE (e.g. the empty string) in the field.

That is both a logical and a useful characteristic of NULL

Wait Dear Friend...
I'm analysing ... i will Update Quickly

Hi

NULL is something like UNKNOWN or NOTHING or MISSING thats it!

So, NULL can not be considered as an EMPTY! Even ASCIIs are same for NULL and EMPTY('')

Pandians

So,You r try to say that NULL is a Blank Or Not

hi Hariinakoti

u r right...

Lets not complicate things....

Everytime you see NULL think of it as "I Dont Know "(that's why null+anything = null i.e i dont know +anything= i dont know) now what you dont know is not empty("") or zero(0) however it can be empty or zero.

Ex:
viewState("password")= null;

if(viewstate("password") != "")
{
//do somthing here
};

Now here i have assigned password as null(I don't Know) but it may/may not have value, now if it has value i am checking within if parentheses that the value is not empty

Simple isn't it.. :)

Very nice explaination. good.