update tableName set fieldName = replace(fieldName,'abcd','1234')  where fieldName like '%abcd%'
eg:
update T0391H set FH002 = replace(FH002,'XSB','X')  where FH002 like '%XSB%'

