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
CJ
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!!!

Report message to a moderator

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);

Report message to a moderator

Previous Topic: instr()
Next Topic: How can I made db server response quickly?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 04:25:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.