﻿IF EXISTS (SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'usuario' AND COLUMN_NAME = 'identif')
BEGIN
	UPDATE usuario SET identif = CONCAT(identif, '_REM') WHERE Removido = 1 and (identif NOT LIKE '%_REM' AND identif NOT LIKE '%_REMOVIDO');
END