select * from emails where _message contains 'default' or _message is null

returns 180 rows

select * from emails where _message does not contain 'default'

returns 10427 rows

---

 Comments

---

The DOES NOT CONTAIN operations were also much slower than necessary, which was also corrected. Also, the correct queries to get the 10609 rows would be:

select * from emails where _message contains 'default'

select * from emails where _message does not contain 'default'

The reason being that the DOES NOT CONTAIN operator already includes the rows where _message is NULL

---

 Resolution

---

Fixed Problem on 5/10/2008 in version 1.09 build 4

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial