select _Title,_Forename,_Surname, _sTitle+' '+_sForename+' '+_sSurname from contacts where _forename is null

_Title etc are VARCHARs
_sTitle etc are computed from IF(field is null,'',field)

---

 Comments and Workarounds

---

The workaround is to define the computed column length long enough to accomodate the source expression.

---

 Resolution

---

Fixed Problem on 6/22/2008 in version 2.01 build 1

---

 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