• 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.