Hi All,

I have an imported database with a field name as follows:

First name

So because it has a space between the words, I am having troubles writing a query for it. Does anybody know the syntax to do this? I tried the following with now luck:

Bring empty set even with a Joe in the table
SELECT * FROM table WHERE 'First name' = "Joe";

Same...
SELECT * FROM table WHERE "First name" = "Joe";

Gives error in syntax...
SELECT * FROM table WHERE First name = "Joe";

Any help would be appriciated.

I suggest you remove the space in the field name (firstname) or replace the space with an underline (first_name).

Thanks for the reply!

A good idea, but I'm not sure if I can rename it. The data is coming from a daily download from a MS SQL export to Excel with about 60 different fields. It would be extremely time comsuming to do on a daily basis. It's a pretty big database.

Is there some sort of script out ther to do this?

You need to use reverse quotes: `First Name`

Ah! That did it!!!! Thanks!!