How to update information of the data of column in the table matching the certain text?
Its easy : REPLACE (string_expression,string_pattern,string_replacement)

CREATE TABLE FirstLastName
    ([Firstname] varchar(9), [Lastname] varchar(6))
;

INSERT INTO FirstLastName
    ([Firstname], [Lastname])
VALUES
    ('ABCDEF', 'GHIJKL'),
    ('BFGABCF', 'FGYUTY'),
    ('CDFSERABC', 'VVVVVV')
;


select * from FirstLastName


--- now update the table 

update FirstLastName 
set Firstname = replace (Firstname,'ABC', 'XYZ')
-- optional (else it will do an upadte to entire table) !!
--where somecondition


SQLFIDDLE HERE