1 Reply Latest reply: Dec 18, 2012 6:57 AM by François Degrelle RSS

    Merge and Split Concatinate

    Moazam Shareef
      Guyz,

      I'm putting two fields into one.
      :MN_MENU_SEC.MENU_ID := :MENUS.H_MENUID||'-'||:MENUS.V_MENUID;
      how can i split one into two?
      :MN_MENU_SEC.MENU_ID (total 8 characters)
      :MENUS.H_MENUID (From 1st to Four here)
      :MENUS.V_MENUID;(from four to last here)
      Regards
      Moazam