select _subject from mandn
where _subject collate ansi_ci like '%delphi3%'

---

 Comments

---

The issue was related to the trimmed comparison changes in 1.03 to comply with the SQL 2003 standard for only comparing strings without any trailing spaces combined with the default ANSI or Unicode collations. The comparison routines for these built-in collations were not handling the comparison of an empty string against a non-empty string properly.

---

 Resolution

---

Fixed Problem on 6/5/2007 in version 1.04 build 1

---

 Products Affected

---

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