Problem in Sql..

[anilreddy76]

Hi,

I'm having one table with the column name as "description" and it has the following values.

"2BELL","WINDWARD","GLENRIDGE","ALLEN","FF_Fairfield",SD_SanDiego,"SF_Southfield".

I've written the following query to make every thing as lower case and INITCAP of first letter and also the to retrive the characters after "_".

I'm facing one problem here,Query is working fine,but for "2BELL" it is retrieving me as "2bell",I want to display it as "2Bell".

Select INITCAP(lower(trim(substr(data_center.DESCRIPTION, instr(data_center.DESCRIPTION, '_', 1)+1)))) as datacenter from data_center;

Please advise me for any suggestions..

Thanks,
Anil