-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
SELECT 'UPDATE '+TABLE_NAME+' SET '+COLUMN_NAME+' = REPLACE('+COLUMN_NAME+', ''bla bla'', '''')'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE='varchar'
