Home » SQL & PL/SQL » SQL & PL/SQL » SELECT THE DATA WITH ANY CASE (Windows XP)
SELECT THE DATA WITH ANY CASE [message #326409] Wed, 11 June 2008 06:33 Go to next message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member

Hi,

I want to select the data through the Remarks entered in the entry. They were use Upper case and Lower Case. I need to select the data for any case used in that entry.


For Example:
Documentno  Remarks

82040001    Coffee
82040002    COFFEE



I needed select both document in the select statement.

Please Reply me.

Thanking you.
Re: SELECT THE DATA WITH ANY CASE [message #326413 is a reply to message #326409] Wed, 11 June 2008 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version with 4 decimals?

Regards
Michel
Re: SELECT THE DATA WITH ANY CASE [message #326424 is a reply to message #326413] Wed, 11 June 2008 06:49 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
WHERE upper(remarks) = 'COFFEE'
Previous Topic: help in sql
Next Topic: Significance of ROWNUM =1
Goto Forum:
  


Current Time: Fri Dec 02 21:04:46 CST 2016

Total time taken to generate the page: 0.29028 seconds