Initcap & Apostrophes

[gkrenton]

I have a statement that reads
select inv_id, initcap(short_description),
from ecat_items

Which give the short description the first letter capitalization which I want the problem I'm running into is descriptions with apostrophes within them.
children's boots gets displayed as Children'S Boots.

I don't want the 'S capitilized. Anyone know of a way to get both the first letter capitlization result but keep the grammer/apostrophed letters from becoming capitalized as a 'new' word?

Thanks

Gina

 

[PHV]

You may try this:
SELECT inv_id, REPLACE(INITCAP(short_description), [tt]"'S", "'s")[/tt]
FROM ecat_items

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mberni]

what about

initcap(substr(shortdescription,1,1))||substr(shortdescription,2)

?

 

[gkrenton]

Thanks that works as well.