Capitolizing the first and last letter

vijayasarathi7 · Post by **vijayasarathi7** » 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

RPhani · Post by **RPhani** » 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

ray.wurlod · Post by **ray.wurlod** » 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