Re: Help!!! Data Merge

I only have one suggestion. Don't. Leaving dates and times separate makes them much easier to code with and update through ISQL. So you use an extra few bytes per record, so what. Ease of maintenance should be the main aim. Does anyone else agree / disagree / think I'm talking bollocks ?? Mike. In article <57vldr$lth@lana.zippo.com>, Sham Vaidya <?@?.?> writes >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 -- Mik Hobbs