use of 'index' as a field name

[rsstonejr]

Hello.

I'm working on an application where the original developer used the
field name 'index'. This works ok when accessing the table from MS
Access through query, but when I try to reference it via SQL with
either a statement from Enterprise Manager or a stored procedure I'm
getting an error because 'index' is a keyword.

Is there any way to reference this? Maybe some delimeters I can put
around it that I don't know about?

Thanks,
Stoney

[Simon Hayes]

<rs*******@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

Hello.

I'm working on an application where the original developer used the
field name 'index'. This works ok when accessing the table from MS
Access through query, but when I try to reference it via SQL with
either a statement from Enterprise Manager or a stored procedure I'm
getting an error because 'index' is a keyword.

Is there any way to reference this? Maybe some delimeters I can put
around it that I don't know about?

Thanks,
Stoney

You can use brackets:

select [index]
from dbo.MyTable

See "Using Identifiers" and "Delimited Identifiers" in Books Online, as well
as "Reserved Keywords".

Simon

[rsstonejr]

Perfect. Thanks.

When I tried it, I referenced it as:

[tablename.index]

That didn't work.

Thanks again,
Stoney

[vjdileo]

use
select [#mytest].[index],...
from #mytest

not
select [#mytest.index]...
from #mytest

hth,

victor dileo

[Erland Sommarskog]

(rs*******@yahoo.com) writes:

Perfect. Thanks.

When I tried it, I referenced it as:

[tablename.index]

That didn't work.

No, that would be an identifier with that very name with a period
in the middle of it. You use the quotes or brackets to delimit the
identifiers in a name.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp