Well, i am not a SQL Developer yet, i am trying to learn anyway :) Can you share an url that would explain my case clearly? I reviewed a few resources but i couldn't understand most of them :(

Sure: (I simply changed AFTER CREATE with AFTER UPDATE) But i guess i am missing something. I tried following: CREATE TRIGGER FileID_replace ON Articles AFTER UPDATE AS BEGIN update Articles set ImageUrl=REPLACE(ImageUrl,'FileID','Fileid') where ArticleID = (select max(ArticleID) as ArticleID from Articles) END GO

Can you tell me which query to use? I tried one, but it works for only latest entry. If editing a previous entry, it does not work. Because my query was relying on increase on articleId.

Hello guys, i am using a module. I want to run a query whenever user updates an article. Reason is: During article update Fileid becomes FileID under ImageURL column, and this causes broken image paths for my case. I want to keep this Fileid thing same whenever an update occurs at database table. Following trigger works for new entries: CREATE TRIGGER FileID_replace ON Articles AFTER INSERT AS BEGIN update Articles set ImageUrl=REPLACE(ImageUrl,'FileID','Fileid') where ArticleID = (select max(ArticleID) as ArticleID from Articles) END However i need a one to keep Fileid whenever an update occurs. Would you please help? Thank you.