Hi. I'm developing some tables in a database using Web Matrix in an effort to update a website I do, and am experiencing some problems. One of my tables is called "areadining". The column headings are CODE, CITYCATEGORY, NAME, ADDRESS, CITY, STATE, ZIP, and PHONE. The records I'm using under CITYCATEGORY are Montezuma, Oglethorpe, and Ellaville. When I run a Test Query, I'm using SELECT * FROM areadining WHERE CITYCATEGORY = "MONTEZUMA". I've also tried running:

SELECT * FROM areadining WHERE CITYCATEGORY = "Montezuma"

When I try to run the test query, I get an error, Invalid Column=Montezuma. Montezuma is NOT of my column headings. What gives?

Any help will be appreciated.

Ken

I am sure that you should wrap Montezuma in single quotes. It should look like this:

SELECT * FROM areadining WHERE CITYCATEGORY = 'Montezuma'

Shannon