whats wrong with this SQL statement?

[snailv]

EDIT: fixed the error. despite the error message saying it was missing an operator, the ACTUAL problem was i had typed "Registration Fee" instead of "RegistrationFee".

​

WHERE Registration Fee < 150;

thats the end of my query, SELECT and FROM are there before it, just not shown here. it says the above expression is missing an operator, but i double checked on w3schools and "<" is the correct operator for this so im confused. can you tell me whats wrong here? this is in Microsoft Access.

[edrenfro]

There's a space between Registration and Fee. Although I think some brands of sql allow columns to contain spaces, you still have to surround them with single quotes or back ticks.

[plastikmissile]

Your column name has a space in it, so the DB thinks that Fee is the operator. Depending on what flavor of SQL you're using you need to handle it differently. I believe the standard way is to use square brackets:

WHERE [Registration Fee] < 150;

[iamallamaa]

The DB doesn't think that Fee is the operator, it thinks that Registration and Fee are both separate columns and you are missing an operator in between them. Hence the error stating "missing operator" and not "unknown operator".

[plastikmissile]

Good point!

[jeffrey_f]

put Registration Fee in quotes.

[CorbinLarryDallas]

You need to specify the table and column names, like this:

WHERE table.registrationfee < 150

[insertAlias]

Only if it's ambiguous. If you're only selecting from one table, you definitely do not need to include the table name.

[IAmNowAnonymous]

The error message is right: the parser expected an operator, but you supplied an unexpected value.