I hope I understand your question. We have a db named res. The job command, under sql server agent/jobs, is 'exec survey' with the db being res. All tables referenced...

The where clause in the @cmd variable.

Thanks

Jim

Here is what I came up with..

UPDATE TBLNAME SET COLNAME = REPLACE(COLNAME, 'xyz.com', 'localhost')

WHERE COLNAME LIKE '%xyz.com%'

Jim

I have found a solution. Thanks for the help.

Jim

Thank you for your response. How do I update the table with this?

thanks

jim

Thanks!!

Jim

Here is my proc

DECLARE

@HMY AS INT,

@STARTDATE AS DATETIME

SELECT

@HMY = HMY,

@STARTDATE = DTSTART

FROM

MM2WODET

WHERE

DTFINISH IS NULL AND

DTSTART IS NOT NULL AND

HPERSON = @USERHMY

IF @HMY > 0

UPDATE MM2WODET SET

DTFINISH = GETDATE(),

DQUAN...

Thanks again!!

Jim

Thanks!

now how do i format it to be 3.40 not 3.4333

Thank you!!

Jim

Thanks!!

Yes it does. I have researched this, but can't seem to make it work correctly. Any thoughts?

Thanks

Jim