update query for existing records based on criteria

• DaveBriCam

  SSCarpal Tunnel

  Points: 4298

  More actions

  February 4, 2013 at 12:58 pm

  #288796

  I'm needing to write a query that updates about 700 records that have "Null" and write the phrase "Individual Purchase if it finds this.... I'm rusty with ad hoc update queries... thought below would work, but not:

  USE TrackIT

  UPDATE dbo.tblTransactions

  SET tblTransactions.Transaction_Type = 'Individual Purchase'

  WHERE tblTransactions.Transaction_Type = Null

  GO

• richard.noordam

  SSCrazy

  Points: 2691

  More actions

  February 4, 2013 at 1:17 pm

  #1584099

  i believe what you want isn't = Null but IS NULL