Month: August 2005

As I promised, this is my post on advanced LIKE clauses.  Previously I’ve only shown you how to do a wildcard search that would act like the dos command “dir A*.*”, returning all the files that start with the letter A.  But there is far more you can do with the LIKE operator. Wildcards themselves…

In the previous post, I covered the WHERE clause.  You should now feel pretty comfortable limiting the number of rows you get to return based on the values in a column.  But I’m sure you’ve already asked “How can I limit based on two different columns?”  I’m glad you asked! You can chain together your…