SQL Select Command With Null Value

Discussion in 'ASP.NET / ASP.NET Core' started by dbireporter, Apr 21, 2010.

  1. How do I use a null value in an SQL select command?

    "SELECT FROM .... WHERE [field name] = ?"

    where ? is a null value or empty field value.
     
  2. Hi,
    NULL drives a lot of devs nuts but you can use Search for it both ways.
    I.E. IS NOT NULL or IS NULL
    You can also sort your output via which columns are returning NULL.
    All the best,
    Mark
     
  3. mjp

    mjp

    There have always been those who say that NULL should be avoided wherever possible. I wouldn't disagree with them.
     

Share This Page