Based on your "Absolutes", here is the logic that you may try:

Declare @SiteID varchar(15)

Set @SiteID = '3000AA'

Select Case when Len(@SiteID)> 4 then

...

You need to modify the system created Stored Proc sp_MSupd_MyTable in the subscriber database by remove the key columns from updating.

Hope this will help.

I am using SQL Server 2000, and the script for creating the Trigger doesn't work. I got "Incorrect syntax near the keyword 'Database'.". Is there any way I can apply...