Thanks Jeff

I decided to just put it into a cursor, then update each one from there.

Thanks for your help. I think I got want I needed now. Thanks!

Jason thanks for your reply. I realize your concern, but the real point is that I want to change the where clause with the case statement according to the value...

Looks great.

When I try to connect to a remote db, I get this error:

Any one know why?

TITLE: Connect to server

------------------------------

Invalid object name 'sys.database_files'. (Microsoft SQL Server, Error: 208)

Thanks everyone!

A couple of things I forgot to mention.

It can't return the time in the format 00:00:00.000 and the date must be in format YYYY/MM/DD.

Yes I thought that at first but, not all of them have lot numbers. So I have to put out the ones that do and get the company for them...

Thanks for your help! I think I got what I needed so I won't bother you with the data.

Thanks!

Please excuse my ignorance but want do you mean by ddl? The structure of the db?

Thanks for the help!!

Could you give me an example on using in a inner join?

Here is want I think you mean by correlate. Let me know if I am right.

Thanks that worked out great as will and it keep it as datetime!

Mark thanks! That was exactly want I was looking for. Datetime always seems to give me problems.

Thanks!

Merry Christmas!

I got it figured out. I put a vbcrlf in and it worked fine in both places.

Thanks for the suggestion.