Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    44

    Unanswered: Field name with [ ]

    Hi guys,

    I am working with a 3rd party software and they have a table TABLE1 with 2 fields

    code,[ABC DEF]

    I am looking to update the field [ABC DEF] using

    update TABLE1
    Set [ABC DEF]='A' where
    [ABC DEF]='B'

    But it is looking for a fieldname 'ABC DEF' which doesn't exist.

    How do I reference a fieldname that has [ and ] in its name?

    Regards,
    Conor

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    See the result of this code
    Code:
    PRINT QuoteName('[ABC DEF]')
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •