Hi,

I have got a problem using the new COALESCE feature.
I use it in the following way:

SELECT FIRST 10
V.Z_Type,
COALESCE(Z_Date, 'not defined') AS Pol
...

Z_Date is a DATE column.

The problem is that the date is displayed as 'YYYY-MM-DD',
while my preferred setting is 'DD.MM.YYYY'.
When I just select the Z_Date column without using COALESCE,
the dates display correctly.

I guess that the date is converted to a different type (varchar?)
by COALESCE, so that my client (IBO) does not know how to format
the date.

Does anybody know what's going on?
Of course, I would be glad about a small workaround ;-)


Christian