Posted on 2007-07-31
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.
SELECT Printer0727.Queue, Printer0727.IP
WHERE (((Printer0727.IP) &.
What would be the syntax on where clause?