rajasekhar.bollareddy (2/25/2011)
so no difference both are same
An empty string an NULL are the same? Nope.
As stated NULL is an unknown value not an empty string (we know it's a string, we know it's empty).
If your having trouble retrieving things from a column that could be either use ISNULL (look in books online). Use with caution as this can be a performance nightmare.
Carlton.