Select * From Mytable
Where Myfield  Not Like '13%'

---

 Comments and Workarounds

---

The issue was specifically with the Portuguese locale and how it collated the numeral 3 with the smaller subscript 3. DBISAM was changed to not do optimized scans on such queries and instead will only execute such a query as a partially-optimized query do the need for an additional record scan to satisfy the NOT portion of the query.

The workaround is to use:

WHERE not (MyField LIKE '13%')

---

 Resolution

---

Fixed Problem on 5/1/2005 in version 4.20 build 1

---

 Products Affected

---

DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source