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]

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

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(en ame,0,3))||lowe r(substr(ename, 3)) from emscs

[KARTHIK1244]

answer

Select ename,lower(sub str(ename,1,rou nd(length(ename )/2)))||upper(sub str(ename,round (length(ename)/2)+1,length(ena me))) a from emp ;

[KARTHIK1244]

Select ename,lower(sub str(ename,1,rou nd(length(ename )/2)))||upper(sub str(ename,round (length(ename)/2)+1,length(ena me))) a from emp ;
executed....... ..............