Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > '[' in column name
User Name
REGISTER NOW! Mark Forums Read

sponsored links

1 6th July 15:07
steve kass
External User
Posts: 1
Default '[' in column name

You'll see the correct way to specify this with the
function QUOTENAME():

select quotename('[Time Period].[BTG][Measures].[FC]')

The result is
[[Time Period]].[BTG]][Measures]].[FC]]]

You could also use
"[Time Period].[BTG][Measures].[FC]"

When using [] to delimit an object name, you must
double any occurrences of ] in the name. Don't
double the occurrences of [ .

Steve Kass
Drew University
  Reply With Quote

  sponsored links


Thread Tools
Display Modes

Copyright 2006 - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -