• update table_name

    set col1 = replace(col1,'XXX','')

    are you using something like this?

    Regards
    Durai Nagarajan