This content has been marked as final. Show 4 replies
select * from emp where ename = upper(substr(ename,1,2))||lower(substr(ename,3))
What would be the correct way to search for this, for example bring back all results where user_name has 2 upper case characters followed by lower case?
If name can be anything after first two upper cases then (Anything other than Upper case)
Edited by: jeneesh on Feb 15, 2013 3:31 PM
Is your usern ame case sensitive? Means, you can have multiple user names like ABcd','ABCD' ? If then it does not look good..If not you could just use upper(user_name) = upper(your_parameter)
I would use simple substring and upper functions
where ename= upper(substr(ename,1,2))|| lower(substr(ename,3));
Any special reason that these users are in lower case. If you want to make them in upper case then you can update that table like
above will set all the useid in upper case.
update table_name set userid=upper(userid)
If you want to search that users then below may be helpfull
SQL> select upper('this is chanchal') a from dual; A ---------------- THIS IS CHANCHAL So you can make changes to the above statement like select userid from table_name where userid=upper(your_userid); SQL>