Using my test database :-
http://files.pioneersoftware.co.uk/temp/edb_testdb.7z

Here's the SQL :-
----------------------
select app.id,
('Appt on ' || cast(start as varchar(20)) || ' [' || per.lastname || ', ' ||
per.firstname || ']') as description, start
from app
join per on (app.per_id=per.id)
----------------------

EDB Manager works fine and returns :-

1011208090258546403 | Appt on 2008-12-01 16:00 [Lastname, Nick] | 2008-12-01
04:00 PM
etc.

In ADO.NET we get :-

1011208090258546403 | Appt on Elevate.ElevateDB.Data.Engine.TEDBParsedDate
16:00 [Lastname, Nick] | 2008-12-01 04:00 PM

Looks like the DATE part isn't being converted properly in the EDB ADO.NET
provider.

Thanks!

Hedley,

<< In ADO.NET we get :-

1011208090258546403 | Appt on Elevate.ElevateDB.Data.Engine.TEDBParsedDate
16:00 [Lastname, Nick] | 2008-12-01 04:00 PM >>

Got it, thanks.

--
Tim Young
Elevate Software
www.elevatesoft.com