remi - your question was not clear enough...you should've said - "in the example posted, it is not clear why dynamic sql is being used - try & avoid dynamic...

..actually, it is...

Don't take no for an answer!

Don't accept candy from strangers...

and

Don't take bad advice from ANYBODY!!!

Far as I remember I had to save as a .png file before I was able to upload...try that!

You can also get loads of information from the "create trigger" page....more specifically...

"The IF UPDATE (column_name) clause in the definition of a trigger can be used to determine if...

Gil - you'll have to post your t-sql (or at least the portion that involves the cursor) for anyone to be able to troubleshoot this for you.

You also stand to...

just realized that nowhere in the link I posted do I mention that this is a cross-post...my apologies..

John - you'd really be better off following my link to the other post since Hasan has this posted at 3 different forums and kenneth is already addressing this in...

sorry...my bad...it should be :

UPDATE cs_ArticleCategories
SET child2 = REPLACE(child2, char(47), char(45)) 
WHERE id = 637

sorry..not thinking st. today..

Aah.....

in your "select...replace..." statement, remove the "AS Expr2"!

Also..where are you running this from...?!?!

Is it possible that you have more than 1 database with the same table name and you're running the code against one but checking...

post the data from at least one sample string...

run it for one sample row and as aaron requested...tell us what you get ?!

try substituting char() instead:

DECLARE @child2 varchar(50)
SET @child2 = 'that is a strange/name for a column'
SELECT REPLACE(@child2, '/', '-') AS Expr1
SELECT REPLACE(@child2, char(47), char(45)) AS Expr2

cross-posted - follow thread here!

Maybe some of the answers can be found here!

You may just have your "here"s all dislocated!..