proper Case

dhulbert · Dec 11, 2006

Is there a tidy way in SQL to proper case a string. Currently I'm using

Code:

upper(left(TBL_PATNT.FORENAME,1))+ 
lower(right(TBL_PATNT.FORENAME,len(TBL_PATNT.FORENAME)-1))

This works fine but I was just hoping to find a way to make the code a little tidier.

Cheers.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

vbkris · Dec 11, 2006

just one more way:

select upper(substring('asd',1,1))+lower(substring('asd',2,len('asd')))

Not necessarily tidy

Known is handfull, Unknown is worldfull

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

proper Case

dhulbert

Technical User

vbkris

Programmer

Similar threads

Part and Inventory Search

Sponsor