| Character Function [message #411391] |
Fri, 03 July 2009 06:41  |
skkazmi
Messages: 42
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
|
|
|
| Re: Character Function [message #411398 is a reply to message #411391] |
Fri, 03 July 2009 06:55  |
JRowbottom
Messages: 5254
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 |
JRowbottom
Messages: 5254
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.
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
