Home Forums Programming General Replace statement RE: Replace statement

  • July 23, 2003 at 3:32 am

    #466544

    Is this what you want?

    update ITEM

    set CTLG_NO = replace(CTLG_NO,'55551111','41331111')

    test it first though


    Growing old is mandatory, growing up is optional