DSXchange

Posted: **Fri Jan 31, 2014 4:02 am**

Hi All,

I have a job, to capitolizing 1st and last letters.

Source
Column_name-varchar
mphasis
satyam
techmahindra
wipro
ibm

Target
Column_name-varchar
MphasiS
SatyaM
TechmahindrA
WiprO
IbM

Thanks
Vijayasarathi

Posted: **Fri Jan 31, 2014 4:30 am**

Hi,

Try this:
Upcase(Left(Column_name,1)):Column_name[2,Len(Column_name)-2]:Upcase(Right(Column_name,1))

-----------------------------------------
RPhani

Posted: **Fri Jan 31, 2014 4:32 am**

vijayasarathi7 wrote:I have a job, to capitolizing 1st and last letters.

Why?

DSXchange

Capitolizing the first and last letter

Capitolizing the first and last letter

Re: Capitolizing the first and last letter