Problem with UPDATE in a query SQL 18.21.1

1

Have a database that has a cell named movies, when I enter a new record the VB program was supposed put an ‘X’ in that cell if the actual digital movie was on the disk. For some reason this didn’t happen on all the records and the cell ended up with ‘NULL in it. When I go back and try to change the ‘NULL’ to an ‘X’ using a SQL query it doesn’t work.

Here is the Query:

use[D:\DATA FILES 092015\DVD_LIST.MDF]
update [DVD_List]
set Movie ='X' Where Movie = 'NULL'

--also tried

use[D:\DATA FILES 092015\DVD_LIST.MDF]
update [DVD_List]
set Movie ='X' Where Movie = NULL

Why doesn’t one of these versions work?

2

one possibility is the syntax

-- this could be the issue
where Movie is null

1 Like
3

Change "Movie = NULL" to "Movie IS NULL"