Working with a field/column that already has brackets in its name
- From: "Usulnet" <gdca@xxxxxxxxxxxxx>
- Date: Thu, 16 Mar 2006 01:00:05 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: Working with a field/column that already has brackets in its name
- From: Richard Mueller
- Re: Working with a field/column that already has brackets in its name
- Prev by Date: Re: VB6 ADO problem *solved*
- Next by Date: Re: Working with a field/column that already has brackets in its name
- Previous by thread: How to speed up ADO connection?
- Next by thread: Re: Working with a field/column that already has brackets in its name
- Index(es):
Relevant Pages
|
