Thanks but the bi-directional merge is no longer a business requirement.

Have eventually discovered that by clicking "default article properties", the option "keep the existing table unchanged" is the option I...

Thanks Steve,

Do you think I would be better with standard auditing?

P

Do you need to record changes, i.e. store old and new customer address?

Think about what type of reports stakeholders will require, this can aid in the design of the...

Instr is not a function in SQL, you need to use Padindex.

Try this in your test database first

UPDATE

 [table1]

SET

 [field1] =

   CASE

    WHEN PATINDEX ('%.%', [field1]) > 1 THEN SUBSTRING ([field1], PATINDEX ('%.%', [field1]) - len([field1]), len([field1]))

    ELSE [field1]

   END

All my "string" fields are VARCHAR so I'll remove that charindex. Performance has been bearable 15,000 scanned in 10 seconds.

Hi John,

Noticed you'vre removed the "Like" and replaced with "Charindex" is this for performance?

Thanks

David

PS - might even make the undesired character a parameter, in case something else like this occurs...

Hi John,

Cool thanks for that. Like your way because I want to remove the offending character, so I could change that easily to an update.

I found the data by

1. Scripting the table...

Have seen this myself when the user's default database has been deleted/renamed. Change the default to Master - give it another go.

Cheers

Not the cleanest but it works...

__________________________

CREATE  PROCEDURE [usp_ExportXML] AS

DECLARE @TableName varchar(50)

DECLARE @BCPSTRING varchar (255)

DECLARE tableList CURSOR FOR

select TableName from TableUpdateLog where Updated = 1

OPEN tableList

FETCH NEXT FROM tableList

INTO @TableName

WHILE @@FETCH_STATUS...

Lookup REPLACE in BOL, essentially it's

SELECT

[field 1],

REPLACE ([yourfield here], '.', '')

FROM

table

Does the 2nd point mean you can't ever connect? Have you tried adding a new server registration, if this fails then you're not going to be able to replicate when...