SELECT _BoxNo, _BoxName,_Unread, _IsFolder
from "BandA"
WHERE CAST((_BoxNo / -100000) AS INTEGER) = 3
ORDER BY _BoxNo DESC

---

 Comments and Workarounds

---

The workaround is to use the TRUNC() function to truncate the value prior to the CAST() call. EDB was being a bit over-zealous with its truncation checks and was including fractional truncation in the checks instead of just checks on significant digit truncations (range errors).

---

 Resolution

---

Fixed Problem on 1/3/2008 in version 1.07 build 2

---

 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