Вот кусок из триггера который делает примерно то что надо:
CREATE TRIGGER dbo.products_ins
ON dbo.products
FOR INSERT AS

declare
@rc int,
@syb_err int,
@affected_rows_pr int,
@affected_rows_po int,
@affected_rows_req int

--
-- Initialization Variables
--
select
@syb_err = @@error,
@affected_rows_pr = @@rowcount,
@affected_rows_po = 0,
@affected_rows_req = 0,
@rc = 0
--
-- Check error and qty of inserted rows in product
--
if @syb_err != 0 goto syb_err
if @affected_rows_pr = 0
return
/*******************************************************************************/
/* 05.30.02 E.K. Quotes replacing */
/* Any of symbols in [] in the col."security_description" */
/* table "products" ['"()] replaced by one space in loop (according to O.L.) */
/* self_recursion is off by default, so trigger will not fire again */
/*******************************************************************************/
--
-- Initialization loop variable with anything > 0
--
declare
@affected_rows_qts int
select
@affected_rows_qts = @affected_rows_pr /* Anything > 0 */
--
-- Looping through string for all updated with quotes rows
--
--if update (security_description) --or (for all other columns need to put under or and set clauses)
while (@affected_rows_qts > 0)
begin /* Loop */
update products
set prd.security_description = stuff(prd.security_description,patindex("%['()""]%",prd.security_description),1," ")
from products prd, inserted i
where patindex("%['()""]%",prd.security_description) > 0
and prd.cusip = i.cusip
--
-- Check error and qty of updated rows in product
--
select @syb_err = @@error,
@affected_rows_qts = @@rowcount
if @syb_err != 0 goto syb_err
end /* Loop */
--
-- Debug: Should be deleted
-- select i.security_description, prd.security_description
-- from products prd, inserted i
-- where prd.cusip = i.cusip
--
/********************************************************************************/
/* End 05.30.02 E.K. Quotes replacing */
/********************************************************************************/