SQL pattern matching with MS Access
Not what you're looking for?
Why wont this query give me any results?
SELECT author_name
FROM authors
WHERE author_name = "*Twain, Mark*";
After all, the text string
Twain, Mark
does exist in the author_name table.... (try it out using the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here.
Purchase this Solution
Solution Summary
This solution shows how to do pattern matching in a MS Access SQL query. It explains the difference between an exact match and pattern match string comparison.
Solution Preview
This query is a valid query but it's probably not doing what you expect. When searching on text fields there are two ways to search the text. One is an "exact match" and the other is a "pattern match". Using the "=" symbol tells Access to perform an exact match. Using ...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
C# variables and classes
This quiz contains questions about C# classes and variables.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Basic Networking Questions
This quiz consists of some basic networking questions.