NULL varchar

• Nikola Tesla-229239

  Old Hand

  Points: 329

  More actions

  May 23, 2005 at 3:25 pm

  #362733

  for some reason this query does not work:

  SELECT *

  FROM Orders

  WHERE Event <> 'Point of Sale'

  it fails when the column Orders.Event is NULL. is there a better way to search varchars

  without having to use:

  SELECT *

  FROM Orders

  WHERE ISNULL(Event, '') <> 'Point of Sale'

  SELECT *

  FROM Orders

  WHERE Event NOT LIKE 'Point of Sale%'

  ---

  There are ll types of people: those who understand Roman Numerals, and those who do not.

• ron k

  SSCertifiable

  Points: 6103

  More actions

  May 23, 2005 at 8:46 pm

  #560647

  By default any comparison to null using =, <> etc. will always compare as false.  When comparing to null try to use IS NULL or IS NOT NULL.

  For example:

  SELECT *

  FROM Orders

  WHERE Event <> 'Point of Sale'

  Or       Event IS NULL

  btw there is nothing wrong with:

  WHERE ISNULL(Event, '') <> 'Point of Sale'