update cli_branches
set brch_name = rtrim(brch_name,'(NO PHONE #S)')
where upper(brch_name) like '%PHONE%';


Janet Linsy <[Email Address Removed] wrote:
Hi all,
I need to update a column (brch_name) to be without
(NO PHONE #S) string. So 3954 will be Denver, 3955
will be Golden, and 3963 will be LOVELAND 29TH, etc.
How to write this update statement??? Thank you!

1* select brch_id, brch_name from cli_branches where
upper(brch_name) like '%PHONE%'
SQL> /

BRCH_ID BRCH_NAME
---------- ------------------------------
3954 DENVER (NO PHONE #S)
3955 GOLDEN (NO PHONE #S)
3956 ENGLEWOOD (NO PHONE #S)
3957 LITTLETON (NO PHONE #S)
3958 CHARLOTTE (NO PHONE #S)
3959 S LEMAY (NO PHONE #S)
3960 HARMONY ROAD (NO PHONE #S)
3961 ENGLEWOOD (NO PHONE #S)
3962 LOVELAND (NO PHONE #S)
3963 LOVELAND 29TH (NO PHONE #S)
3964 DENVER (NO PHONE #S)

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Oracle LazyDBA home page