Thanks anyway

How do I set that up in DTS?

Thanks for the reply

That did the trick, many thanks

what I really want to do is drop them so it would read 'A1EC1-52'

Thanks for all the help.  I figued it out.  The final query follows:

--build the query

select 'L' as RECTYPE, identity(int, 1, 1)as JELINENO,

--Get the current JENO from the issuesreturns table

(select max(JENO)...

I figured this out.  The answers is:

(select max(JENO) + 1 from issuesreturns) as JENO,

That seemed to do it.

Thanks for your help

Here is a much larger snippet of the code:

--build query default value columns

select 'L' as RECTYPE, identity(int, 1, 1)as JELINENO, '800002' as JENO, 'AJE' as JECODE,

'2006' as FY,

-- The...

That did the trick

many thanks

That did the trick.  Thanks for the help.

Dave