Home » SQL & PL/SQL » SQL & PL/SQL » Return lower case fields
Return lower case fields [message #842] Thu, 07 March 2002 11:18 Go to next message
Messages: 8
Registered: September 2000
Junior Member
Is there a way to return all records that were entered in lower case? The only thing I could find was the Lower() function which converts things to lower case. Any help is greatly appreciated!!!
Re: Return lower case fields [message #849 is a reply to message #842] Fri, 08 March 2002 04:40 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
this is query checks for one column. you can modify this query to include more columns

select * from table1 where col1=lower(col1);
Previous Topic: instr()
Next Topic: How can I made db server response quickly?
Goto Forum:

Current Time: Wed Oct 27 04:18:26 CDT 2021