Apart from the syntax being wrong, the query should not return if container_name has the string "BOX1" in it. Is the name of the table PATIENTS, or [PATIENTS LIST]? If it is the latter, you should use the square brackets as shown. Also, the second WHERE will cause a syntax error.