?
Solved

Not Like

Posted on 2007-07-31
3
Medium Priority
?
215 Views
Last Modified: 2010-03-20
I have a long list of the info with two fields below in a table.

What I want is to extract all of the rows EXCEPT *******s*.    For instance, hjwbgl242s2, hgbc469s1, p1109045s1, etc are to be removed.    The format of those specific rows are ******** and letter s and followed by a number.    The number of characters right before s can vary, but once it hits s, then there is always one integer followed by.  

Queue              IP
hjwbgl242p2      10.6.90.174
hjwbgl242s2      10.6.90.174
hgbc469p1      10.3.4.50
hgbc469s1      10.3.4.50
p1109045p1      10.40.112.41
p1109045s1      10.40.112.41
lb22pedser      10.6.91.53
lb32c8a      10.3.8.254
lb38s11d      10.2.11.122
lb14n12w      10.1.12.46
lb64s5c      10.2.5.31
lb73w5a      10.38.80.5
&&..

SELECT Printer0727.Queue, Printer0727.IP
FROM Printer0727
WHERE (((Printer0727.IP)  &.

What would be the syntax on where clause?

thx much
0
Comment
Question by:ethanjohnsons
  • 2
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 19601802
WHERE Queue NOT LIKE "*s#"                   <--------- Access
WHERE Queue NOT LIKE "%s[0-9]"              <--------- SQL Server (?)
0
 

Author Comment

by:ethanjohnsons
ID: 19665390
thx much
0
 
LVL 61

Expert Comment

by:mbizup
ID: 19665414
Glad to help :-)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question