Share
Explore BrainMass

How would I have to modify this query to get it to run correctly?

Let's say my author name column in the table "authors" (in the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here) was named:

author name (not author_name, as it is currently named)

This is OK to do (to use "whitespace" in a column or table name), but how would I have to modify this query to get it to run correctly?

SELECT authors.author name
FROM authors
WHERE authors.author name Like "*twain*";

Attachments

$2.19