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).

tia,

Bob M..