WOW...

Thanks a lot..

Thank you!

Thanks a lot Jeff,

it worked beautifully!!!

Try this

SELECT

EMPLOYEE,

MIN(EFECT_DATE) AS EFECT_DATE,

MAX(END_DATE) AS END_DATE,

JOB_CODE

FROM TABLE

GROUP BY EMPLOYEE,JOB_CODE

HAVING JOB_CODE ='T009'

Thanks guys..

Thank you!!!!

Drew,

Thank you much.. the second sample did it..

Sorry to confuse you, I trew that extra order that have only 3 items and were completed.

As you see the last column ORDER_STATUS, that is the column I need help...

Just another column 'ORDER_STATUS' = 'PARTIAL'

ITEM_STATUS ORDER_NUMBER UNIT_NUMBER ORDER_STATUS

50 ...

Thank you guys...

Would you please provide an example - for the variable?

Thanks

Yes,

The total size is 46 characters, divided by

1-17 acct # right justified,

18-27 left justified, 0 filled,

etc..etc,to 46 , I have managed that piece -

SELECT...

Thank you - thank you

It worked,

There was a trigger, follow your suggestion, ran code again and "YES!" it worked..

Thanks a lot..

it worked, it was under maintenance, you would think it would be under install.. Anyway...

Thanks !!! a lot