SQL Statement: "top" field

[CiberTHuG]

I'm using SQL Server, and I get a syntax error on a syntax error on a statement that uses "top" as a field name. But the table has a field named top, so how I do SELECT it?

'This gives me an error
SQL = "SELECT myField, top, myOtherField FROM myTable"

[rudgej]

What about (not certain - but worth a try)

SQL = "SELECT myField, [top], myOtherField FROM myTable"

or

SQL = "SELECT myField, top.myTable, myOtherField FROM myTable"

[CiberTHuG]

No luck. I also tryed...

SQL = "SELECT myField, myTable.top, myOtherField FROM myTable"
SQL = "SELECT myField, myTable.[top], myOtherField FROM myTable"
SQL = "SELECT (myField, myTable.top, myOtherField) FROM myTable"
SQL = "SELECT (myField, myTable.[top], myOtherField) FROM myTable"
SQL = "SELECT (myField, top, myOtherField) FROM myTable"
SQL = "SELECT (myField, [top], myOtherField) FROM myTable"

[rudgej]

Sorry then! It's bugging me now - so if I find something when I get to work tomorrow, I'll post the answer.

[CiberTHuG]

I got it to work.

SQL = "SELECT myTable.myField, myTable.[top], myTable.myOtherField FROM myTable"

[Gary.Lowe]

Top is a reserved word in SQL 'SELECT TOP 5...'
It is always best to try and add a prefix if you need to use a word that is also a reserved word. Same as naming a field 'Date' SQL can get confused

[rudgej]

CiberTHuG, it looks like you just about had every permutation, and I'm glad you finally cracked it!