Home » SQL & PL/SQL » SQL & PL/SQL » Character Function
Character Function [message #411391] Fri, 03 July 2009 06:41 Go to next message
skkazmi
Messages: 44
Registered: April 2006
Member
Hi All,

Is their any option to convert text 'National Manager Is' to 'National Manager IS'.
I am using InitCap function but it change also 'IS' like 'Is'.
In oracle is it can be posible with the help of built-in functions.

Is their is any option to convert.

Thanking You,

Best Regards,
Khurram

[Duplicate messages deleted by LF]

[Updated on: Fri, 03 July 2009 07:23] by Moderator

Report message to a moderator

Re: Character Function [message #411398 is a reply to message #411391] Fri, 03 July 2009 06:55 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Stop reposting the question - and don't give me that 'it hung and i didn't know if it posted the message' line - these were posted over a total time of 12 minutes. I'm sure you could have spared 30 seconds to see if the post had gone through.

Use REPLACE(your_string,' Is',' IS')
Re: Character Function [message #411401 is a reply to message #411391] Fri, 03 July 2009 06:58 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
STOP POSTING THE SAME MESSAGE

I had time to merge your first three and post a reply to them - that means you had enough time to check if your posts were there.
Re: Character Function [message #411417 is a reply to message #411391] Fri, 03 July 2009 07:55 Go to previous messageGo to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
or can use UPPER Cool
Re: Character Function [message #411419 is a reply to message #411417] Fri, 03 July 2009 08:01 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
ayush_anand wrote on Fri, 03 July 2009 13:55
or can use UPPER Cool


Considering the OP only wants a specific word in uppercase that would be the hard way of doing it.
Re: Character Function [message #411425 is a reply to message #411391] Fri, 03 July 2009 08:29 Go to previous message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Is "National Manager Is" is the only text or you have some column which contains similar values.

could you post DDL/DML for it
Previous Topic: if condition
Next Topic: Weak and Strongly Typed Reference Cursors
Goto Forum:
  


Current Time: Sat Dec 10 22:28:27 CST 2016

Total time taken to generate the page: 0.08974 seconds