Replace statement

• 465789psw

  Hall of Fame

  Points: 3314

  More actions

  July 22, 2003 at 1:24 pm

  #160280

  I want to replace the first part of a string (41331111 to 55551111).

  Table name: 'ITEM' ,col:'CTLG_NO' ,

  look on bol. need a little more help

  THANKS

• bond007

  SSCrazy

  Points: 2056

  More actions

  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

• paul_richardson

  SSCarpal Tunnel

  Points: 4594

  More actions

  July 23, 2003 at 4:13 am

  #466549

  hi,

  shouldn't it be :-

  update ITEM

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

  from 41331111 to 55551111 ?

  Paul

• bond007

  SSCrazy

  Points: 2056

  More actions

  July 23, 2003 at 4:15 am

  #466550

  Yes it should, i forgot to switch the two values back round after a bit of testing. Thanks for pointing that out.

  
  Growing old is mandatory, growing up is optional

• 465789psw

  Hall of Fame

  Points: 3314

  More actions

  July 23, 2003 at 3:32 pm

  #466669

  Thanks thats almost it but I need to keep the last four digits '1111. I looking to replace the first four digits only.

  41331111 55551111

  41331112 55551112

  41331113 55551113

  dont know if a like statment will do?

• paul_richardson

  SSCarpal Tunnel

  Points: 4594

  More actions

  July 24, 2003 at 1:36 am

  #466713

  Hi,

  just use :-

  update ITEM

  set CTLG_NO = replace(CTLG_NO,'4133','5555')

  instead (see replace in BOL for an explanation)

  Paul