Thanks for the help BT. I ended up re-writing the DTS is SSIS since this was the best way to learn. The one thing I can't figure out...

Thanks BT I'll give it a go today and let you know. I appreciate the instructions.

Jeff

Luckily the bad data was not seen as numeric:

select isnumeric([sale price]) as num from dbo.CURRENT_DATA order by num

So it wasn't hard to find.

Jeff

Thanks Jeff. You were correct there was bad data.

Jeff

Thanks Todd. It's starting to look like that may be how I have to do this. I was hoping for another solution as I am running this query...

I did try that first. It gives the error:

Server: Msg 235, Level 16, State 1, Line 1

Cannot convert a char value to money. The char value has incorrect syntax.

ISNUMERIC...

It doesn't happen too often but it happens outside my area of control....

When the VMS application programmer adds a feature to the legacy app (written in DEC basic...

Great thanks Michael.

Jeff

Sure thing I'm more than happy to post the solution. I hadn't posted this as the bulk of the solution is non SQL related, specifically as you mentioned, to...

The part time is the problem not the remote or the rate. 'Part time' would still need to be 24 - 32 hours a week for it to be worth...

It would depend on thier ability

Great thanks Gila.

Thanks mrpolecat I was simply missing the correct number of 'end' statements..............

Thanks for the answer. I didn't think it was me.

Thanks MKEast !!!!!!!!!!!!!!!!!!!!!!!