create procedure dbo.Forum_FilterWordUpdate

@PortalID   int,
@BadWord nvarchar(50),
@ReplacedWord nvarchar(50),
@CreatedBy int

as

if exists(Select ItemID from Forum_FilterWords where PortalID = @PortalID and BadWord = @BadWord)
begin
    update Forum_FilterWords
    set
        ReplacedWord = @ReplacedWord,
        CreatedBy = @CreatedBy,
        CreatedOn = GetDate()    
    where
        PortalID = @PortalID
    and     BadWord = @BadWord
end
else
begin
    insert into Forum_FilterWords
    (PortalID, BadWord, ReplacedWord, CreatedBy, CreatedOn)
    values
    (@PortalID, @BadWord, @ReplacedWord, @CreatedBy, GetDate())

end


GO