Re: Help!!! Data Merge

I haven't tried this but it should work. select extend(start_date,year to day)||" "||start_time from table a into temp xxx once it's in your temp table you can do whatever you need to with it -- Joseph Cullipher |E-mail: joseph@cannonexpress.com PO Box 364 |opinions express are those of my own and Springdale, AR 72764 USA |don't necessarily reflect those of my company On 2 Dec 1996 Sham.Vaidya@rmy.emory.edu wrote: } H-E-L-P !!! } } Could someone advise me on what my options are } } I have 2 fields on table A } } start_date - type date } start_time - type datetime hour to second } } I have created a new on Table A called } start_datetime - type datetime year to second. } } Is there any way using a simple SQL statement I can concatenate start_date } and start_time into start_datetime? Any other way? Any ideas appreciated.... } } Thanks } } Sham } } Email: smvaidya@auto.rockwell.com }