SELECT hdr_callback, REPLACE(hdr_callback, 'https', 'http') FROM System.[Form.Headers] WHERE hdr_callback LIKE '%https%' UPDATE a SET a.hdr_callback = REPLACE(hdr_callback, 'https', 'http') FROM System.[Form.Headers] a WHERE hdr_callback LIKE '%https%' SELECT a.col_controlexpr, REPLACE(col_controlexpr, 'https', 'http') FROM System.[Form.Details] a WHERE col_controlexpr LIKE '%https%' UPDATE a SET a.col_controlexpr = REPLACE(col_controlexpr, 'https', 'http') FROM System.[Form.Details] a WHERE col_controlexpr LIKE '%https%'