Can anyone explain me what are the main difference between a null value and blank value in database. It important please help me out. thank you.

1.A NULL value represents the absence of a value for a record in a field (others softwares call it also a missing value).

2.An empty value is a "field-formatted" value with no significant data in it.

3.NULL isn't allocated any memory, the string with NUll value is just a pointer which is pointing to nowhere in memory. however, Empty IS allocated to a memory location, although the value stored in the memory is "".

4.Null has no bounds, it can be used for string, integer, date, etc. fields in a database. Empty string is just regarding a string; it's a string like 'asdfasdf' is, but is just has no length. If you have no value for a field, use null, not an empty string.

5.Null is the database's determination of an absense of a value logically, so to speak. You can query like: where FIELD_NAME is NULL

Good explanation shanti.

I would also say that null is much easiet to query for than a blank value.

Thanks guys but i have one query, if i have some null values and some empty string in the table and if i execute select * from from table. whether it will print fields having null and empty string ? what will be the o/p?

select * from tablename;
this statement will print all the columns, not the matter of null or empty..

if you need to filter out empty strings

filter out nulls

if you need both, just combine

i use this on a daily basis
SELECT * FROM table WHERE isnull(column,'') = ''
or other variations ....
SELECT * FROM table WHERE not isnull(column,'') = ''
SELECT * FROM table WHERE isnull(column,'') <> ''