1

Hi, Please advice how can I convert ‘name’ entered by user to Title Case via Peoplecode and also SQR. Thanks

2

Use Peoplecode function Proper(string)

Description

Use the Proper function to capitalize the first letter in a text string
and any other letters in a text string that follow any character other
than another letter. It also converts all other letters in a text string
to lowercase. Punctuation and other characters that have no case
sensitivity are not changed.

Returns

Returns a String value with the first character of each word
capitalized.

3

use the funtion proper(string)

The example sets the value of &BADKD to “K. D. Lang”.

&BADKD = Proper(“k. d. LANG”)

From: sudheerbollam via peoplesoft-hr-l
[mailto:peoplesoft-hr-l@Groups.ITtoolbox.com]
Sent: Fri 12/8/2006 4:20 AM
To: REDDY Vahini Katta
Subject: RE:[peoplesoft-hr-l] RE: convert Upper Case to Title Case/Mixed
Case

Hi

I am new to PS and i want to write people code so that the first
characters of the field should change to CAPS.

can i get help how to write this program.

thanks
suresh

Confidentiality Statement:

This message is intended only for the individual or entity to which it
is addressed. It may contain privileged, confidential information which
is exempt from disclosure under applicable laws. If you are not the
intended recipient, please note that you are strictly prohibited from
disseminating or distributing this information (other than to the
intended recipient) or copying this information. If you have received
this communication in error, please notify us immediately by return
email.

4

Use InitCap on the sql that stores the field

sudheerbollam via peoplesoft-hr-l wrote:

Hi

I am new to PS and i want to write people code so that the first characters of the field should change to CAPS.

can i get help how to write this program.

thanks
suresh

Have a burning question? Go to Yahoo! Answers and get answers from real people who know.

5

Hi,
An appropriate example…

SELECT INITCAP(COMPANY) FROM TABLENAME for oracle databases. Here the
word company will have C in caps.

Regards,
Safi.

6

Hi

I am new to PS and i want to write people code so that the first characters of the field should change to CAPS.

can i get help how to write this program.

thanks
suresh

7

If you are talking about converting first character in uppercase and others
in lower case then you can use ‘initcap’ function in SQR and ‘proper’
function in PeopleCode.