Unfortunately I am unable to amend the database structure as the fields are specified by a system vendor.

Hi,

Here's my query, I really would appreciate it if you could help me.

Thanks,

SELECT  

 WT_ADD_OP,  WT_ADD_DATE, WT_EDIT_OP,, WT_EDIT_DATE, 'N',  '211',  ,

 LR_REV,  WT_END_DATE,  '0', WT_SHIFT,  LR_REV,  '20061212',  DATEADD(Second,

  (FLOOR(LR_DAY_END_TIME / 10000) * 3600) +

  (FLOOR((LR_DAY_END_TIME - (FLOOR(LR_DAY_END_TIME / 10000) * 10000)) / 100) *...

Hi John,

I would prefer a sequential numeric field

Hi, The additional field should be a numeric.

ADD_OP, ADD_DATE, EDIT_OP, EDIT_DATE,'n','202', LR_REV,END_DATE, '0', W_SHIFT, LR_REX

The basic data would be :-

SYS, 01/12/2006, SYS, 01/12/2006,n,2002,MCHN1,02/12/2006,0,SHIFT1,END

I would like the proposed data to be :-

SYS, 01/12/2006, SYS, 01/12/2006,n,2002,MCHN1 +...

Great Thankyou for your prompt reply.

Out of Interest is it possible to split a date down so I could just have the Year, or the month or date

Eg :-

2006/12/31...