Posted by Erland Sommarskog on 07/09/05 00:25

(rsstonejr@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, esquel@sommarskog.se

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

• Next in forum: Re: Complicated query - select based on value
• Prev in forum: Re: Query error during runtime
• Thread view: Re: use of 'index' as a field name

[Reply to this message]