Computer Science Homework Solutions
#132318
PQ#1 Why wont this query give me any results?
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.
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.
What is this?
By OTA - Overall OTA Rating
Mike Noel, MS - 4.9/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
- Plain text response
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- SQL query for Access - Using the week 2 attachment database attached here with this posting, I need to come up with the proper SQL to answer these six questions which are within the word document: I suppose each of the visu ...
- Queries in Access - I notice when writing queries that Access will add in a semicolon at the end of my query. Its just one of those Access things right? We don't have to remember to write the semicolon, as Access adds it ...
- Access question - Start Access, and then open the FirmPays database. Open the query named " June 2". View the query in SQL and answer the following questions. Explain your answers. Which tables are used in the quer ...
- Address Payments in a Database - Start Access, and then open the FirmPays database located in the le4 folder of the zip file. Open the query named "June 2". View the query in SQL, and answer the following questions: 1. Which tabl ...
- SQL script to create test data - SQL script to create test data
