-1

I am working with database where i need to retrieve distinct values. Example [English enGLish english ....] all this should be displayed as English only. Can anyone tell me how to achieve this.

Thanks in advance

yasmeen
  • 55
  • 1
  • 6
  • Problem is i can not use alter function. Is there any other way to achieve this? And values are inserted by someone else so i do not know what kind of case they have used. It should be done dynamically. – yasmeen Apr 23 '18 at 10:49
  • 1
    @yasmeen You might want to read other answers as well, not only the accepted one. https://stackoverflow.com/questions/1031844/oracle-db-how-can-i-write-query-ignoring-case#1031865 – default locale Apr 23 '18 at 10:51
  • the other answers work too... "SELECT * FROM TABLE WHERE REGEXP_LIKE (TABLE.NAME,'IgNoReCaSe','i');" and "Select * from table where upper(table.name) like upper('IgNoreCaSe')" – Angel Koh Apr 23 '18 at 10:51

1 Answers1

2

Looks like you need function initcap():

demo

select distinct initcap(column_name) from your_table
Ponder Stibbons
  • 14,723
  • 2
  • 21
  • 24