Why isn t my SQL code working?

I get the message:

Invalid column name Crawford when I run this code in SQL Server Express. What is causing this error? The syntax looks correct.

SELECT *
FROM Customers
WHERE FirstName = "Crawford";
7 answers 7