Bob Murdoch wrote:

> I'm trying to concatenate two columns that contain varchar
> information, one for date and one for time.
>
> I can't seem to figure out what FB 1.5 will accept for automatic
> conversion to a DATE data type (dialect 1).
>
> Give a varchar of '5/1/2005' and '10:00 AM', how can I concatenate the
> two into a DATE column?
>
> A simple '5/1/2005' || ' ' || '10:00 AM' does not work (conversion
> error).

CAST ( '5/1/2005' || ' ' || '10:00' AS DATE )
But I'm not sure how you handle the 'AM' I use 24 hour clock ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services