Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by James Travis Is there any difference between a NULL and a Blank field in MS SQL RE: Is there any difference between a NULL and a Blank field in MS SQL

  • October 14, 2008 at 4:36 am

    #884512

    Both are different.Null is value which is unknown.

    If you want to extract the null values use is null

    If you want to extract blank values use = ' '