NOT LIKE ?

-----Original Message-----
From: Jonathan Kerr
[mailto:mssqldba-ezmlmshield-x11305840.[Email address protected]
Sent: Wednesday, 30 April 2008 9:30 a.m.
To: LazyDBA Discussion
Subject: RE: Wildcharacter search

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



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

____________________________________________________________

This e-mail and any attachments may contain confidential information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.

MS Sql Server LazyDBA home page