Perfect! Thanks so much for your help!

Laurie

Thanks again!

I was able to get exactly the payroll records I need from the query!

Now I have also eliminated columns that are not required for the payroll import...

Thanks!

The query is now working!

But unfortunately it is excluding the REGULAR hours for the Hourly employees (as well as the REGULAR hours for the Salaried Exempt - or...

Thanks for the prompt reply!

I tried your query and received this message:

Msg 207, Level 16, State 1, Line 46

Invalid column name 'c5'.

It seems that 'c5' is defined...

Laurie

I've added the table information on the ID field, and I've now removed the comment lines, and I am still gettig the following error:

Msg 8120, Level 16, State 1, Line...

Thank you all for your sugguestions. I will have to check with the requestor on stripping out C/O's, etc. We will definitely need to modify the data somehow...

Thanks, Jeffrey. I should have noticed that, too.

That works wonderfully!

Now, the second part of my task is to take the place the name and email in another...

Thanks for the reply!

Here is what I get when I run your select statement:

Msg 195, Level 15, State 10, Line 6

'COALSCE' is not a recognized built-in function name.

Do I need...