sql query to display half employee name in upper case & other half in lower case

[itishree priyadarsini]

sql query to display half employee name in upper case & other half in lower case

[rski]

Show what do you have so far (I think you tried do it by yourself).
BTW
What is a first half in name 'Joe'?

[OraMaster]

@itishree priyadarsini
Let say there are 100 records in employee table. So you want to display first 50 record's employee name in UPPERCASE and remaing 50 in lowercase? Am I right?
And also tell me what if total number of records are in odd like 101 or 99.

[amitpatel66]

Are you looking at displaying firstname of an employee in Upper case and second name in lower?

[syed naseema]

Try this query:

select upper(substr(ename,0,3))||lower(substr(ename,3)) from emscs

[KARTHIK1244]

Select ename,lower(substr(ename,1,round(length(ename)/2)))||upper(substr(ename,round(length(ename)/2)+1,length(ename))) a from emp ;

[KARTHIK1244]

Select ename,lower(substr(ename,1,round(length(ename)/2)))||upper(substr(ename,round(length(ename)/2)+1,length(ename))) a from emp ;
executed.....................