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?