Query Question

What would be the correct syntax to search these two fields, one called "product_id" and the other "width(in)"? I've tried this:

Select product_id, width(in)
From table

But I get an error message saying "incorrect syntax near the keyword 'IN'? It thinks I'm using the sql syntax "in" but I'm not. That's part of the name of the column.

be more specific...what are you wanting to search the fields for?

I'm not searching anything specifically. The query like the one I'm trying to work is all I need to run.

I'm not understanding what you are trying to do with the width(in) part.
If you aren't searching for anything specific, then why not just do this?

No it's because the "(in)" is part of "width". So the column name is "width(in)". But if I try to run it like that it won't work. You see what I mean?

Try

There it is. Exactly what I needed. Thanks Memnoch!