Sorry, misread the question

WHERE column_name LIKE '%[a-z]%' = all alpha characters

WHERE column_name LIKE '%[0-9]%' = all numeric characters

Not sure bout tha wildcards

-----Original Message-----
From: Pillai Sreelatha
[mailto:mssqldba-ezmlmshield-x76096591.[Email address protected]
Sent: Wednesday, 30 April 2008 8:11 a.m.
To: LazyDBA Discussion
Subject: Wildcharacter search

How do i search on only rows with wildcharacters(anything other than 0-9
or a-z) on a column. Anyone has a script for this. Thanks



This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page