ARGH - Stupid database naming

[FuzzyBee]

So I'm trying to pull data from a Sybase DB, and I've discovered that one of the fields I need to pull is named "index". Every time I try to query for it, I get an error. tablename.index gives me an error. Any suggestions?

 

[joinT]

Does Sybase use SQL?

 

[FuzzyBee]

yup

 

[oog]

put it in square brackets like this: [index]

 

[FuzzyBee]

Originally posted by: oog
put it in square brackets like this: [index]

nope - doesn't work. who in the heck names a field "index", anyway? argh!

 

[joinT]

Can you try

SELECT * FROM Index AS newname

 

[FuzzyBee]

It looks like MS Query balks whenever it sees the word index. It looks like I was finally able to use the Sybase SQL tool to query for "index".

Whomever named this field index should be shot.