Querying a column with brackets in its name
- From: "Usulnet" <gdca@xxxxxxxxxxxxx>
- Date: Thu, 16 Mar 2006 04:29:21 GMT
Hi All,
I was hoping someone has experienced this before, I'm having trouble
googling this. I'm working with a poorly writtend database that has some
fields named as such: MTIC_PROD_VEND[ 1]
I do not have the option to rename this field but I do need to retreive data
from it with SQL. I've tried a suggestion of [MTIC_PROD_VEND[ 1]]] and that
doesn't seem to work, it may be because the 1 has a space leading it. Does
anyone happen to have any suggestion to try to work around this? Any
assistance would be greatly appreciated. Thanks.
Regards,
Stephan
.
- Follow-Ups:
- Re: Querying a column with brackets in its name
- From: Erland Sommarskog
- Re: Querying a column with brackets in its name
- From: Stu
- Re: Querying a column with brackets in its name
- Prev by Date: Re: Finding the natural key
- Next by Date: Re: Querying a column with brackets in its name
- Previous by thread: Compare given period in current year / previous year
- Next by thread: Re: Querying a column with brackets in its name
- Index(es):
Relevant Pages
|
