That did it! Thanks for the patience and assist. I really appreciate it.

Hopefully I have this correct per request.

USE [Test_DB]

GO

/****** Object: Table [dbo].[ProjectTree] Script Date: 12/21/2014 11:02:58 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ProjectTree](

[ChildProject] [int] NOT NULL,

[ProjectID] [int]...

Query did not work. ProjectTree does not have a column called Name

See attached images for tables and columns.

Also see query I am currently using and result.

Thanks for the assist.

Yup - that did the trick! Too easy.

USE EPDM

Update dbo.SearchFavoriteValues Set Value = replace(Value, 'C:\EPDMDocManager', 'C:\EPDM');

Thanks!

Thanks very much - truly appreciate the quick response and guidance!