If you are using oracle
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions065.htm
As in
Select initcap('$fullname$') from dual
In a set - fields action.
On Apr 22, 2016 9:39 AM, "Rick Cook" <[email protected]> wrote:
> **
>
> You will have to sequence the string functions. Use one to identify the
> first character of each field, then another to ensure that the is upper
> case. Then the next one will ensure that the rest are lower case.
>
> Rick
> On Apr 22, 2016 7:35 AM, "Satya Miller" <[email protected]> wrote:
>
>> **
>> I could only find Upper and Lower. Nothing about Proper Case.
>>
>> On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook <[email protected]> wrote:
>>
>>> **
>>>
>>> The string functions should be able to do that. Look in the appendix of
>>> your AR System documents.
>>>
>>> Rick
>>> On Apr 22, 2016 7:21 AM, "Satya Miller" <[email protected]> wrote:
>>>
>>>> **
>>>> Morning!
>>>>
>>>> I was hoping someone has an idea to help me with something. I have a
>>>> form that has two fields (First Name and Last Name) in it. The data is not
>>>> "clean." I need to convert the data in these two fields to Proper Case.
>>>> In other words, capitalize each word, or if possible even Capitalize
>>>> correctly like O'Connell. I searched the ARSList and the last suggestion
>>>> was from 2005. I was hoping there might be a better solution now.
>>>>
>>>> Thanks in advance for you help.
>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>>>
>>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>>
>>
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
