select L_name from table as

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Check out the functions UPPER, LOWER, LEFT, RIGHT, and Substring to solve this problem.

michaela SSCertifiable Points: 5649 More actions · Answer 2

select upper(left(last_name,1))+lower(substring(last_name,2,len(last_name)-1)) from table_name

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

I didn't answer because it most likely was a homeowrk question... but I guess we will never know know .

prasad mamillapalli Grasshopper Points: 23 More actions · Answer 4

In oracle it works like this

select Initcap(lastname) from table;

and I think michaeal answered it right way.

Andy Warren SSC Guru Points: 119902 More actions · Answer 5

It did feel like a homework problem.