I'm using a dbase adress file with the odbc driver in ReportSmith.
I've defined a derived field fullname with
{fn ltrim( {fn RTRIM("ADR"."FIRSTNAME")} + ' ' + "ADR"."NAME")}

The result is that the resulting string is empty in the case either
name or firstname is missing.

WHY ?

Thanks in advance for your help

Ronny

---------------------------------
Dipl. Math+Inf ETH
Ronny Straus
Spalenring 64
CH-4055 BASEL
SWITZERLAND
TEL: 00 41 61 288 36 43
FAX: 00 41 61 302 13 59
E-Mail: 100273,5...@compuserve.com
---------------------------------