Mombu the Microsoft Forum sponsored links

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

sponsored links


Reply
 
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


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666