[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • Last Modified:

update value

hi i have the following value to update
'LSAOQRAM.form'

 
       
  update tmp_cal_obj
          set obj_name = obj_name||'.fmb' 
          where obj_type = 'form'; 

Open in new window

after update the value must be

'LSAOQRAM.fmb'

how can i do that
0
chalie001
Asked:
chalie001
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
update tmp_cal_obj
          set obj_name = replace(obj_name , '.form', '.fmb' )
          where obj_type = 'form';
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now