USE DB_TEST;
GO

UPDATE T_DIRTY
SET STRING = COALESCE(STRING, '') + '***'
WHERE LEN(COALESCE(STRING, '')) < 500
GO 25