Try some thing like this

Select * from <table> where
length(translate(lower(<colname>),'1234567890abcdefghijklmnopqrstuvwxyz'
,'1234567890')) > 0

-----Original Message-----
From: anuya
[mailto:oracledba-ezmlmshield-x41279850.[Email address protected]
Sent: Thursday, March 30, 2006 6:24 AM
To: LazyDBA Discussion
Subject: Finding Names containing Invalid Characters

Hello,

Plz. help me in this Query.

I want to find all the names which contain an Invalid character (An
invalid character is any character other than 'A'-'Z' and 'a'-'z')



Notice: The information contained in this e-mail message and/or
attachments to it may contain confidential or privileged information. If
you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this
e-mail message and/or attachments to it are strictly prohibited. If you
have received this communication in error, please notify us by reply
e-mail or telephone and immediately and permanently delete the message
and any attachments. Thank you



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
**********************************************************************************************
IMPORTANT: The contents are intended for the named recipient(s) only and may contain information that is
PRIVILEGED and/or CONFIDENTIAL.
If you have received this email in error, please destroy all copies of this message and it's attachments and
then notify the system manager or the sender immediately. Do not disclose the contents to anyone or make
copies thereof.
*** eSafe scanned this email for viruses, vandals, and malicious content. ***
**********************************************************************************************


Oracle LazyDBA home page