CAST(1000023 AS VARCHAR(4)) +'A'+  CAST(1000023 AS VARCHAR(4))

---

 Comments

---

The problem was that CAST() was not respecting the length specified for VARCHAR/CHAR columns, and truncating the column as necessary.

---

 Resolution

---

Fixed Problem on 12/4/2009 in version 2.03 build 7

---

 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 LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial