Column name contains special character

[pricter]

Hi all,
I have a column that its name contains special character for example (Product?)
when I wrote in TM1 process
SELECT [Product Name?]
FROM [GOSALES].[dbo].[Special Characters Test]
I get the error
"SQL Statement Failed"
when I wrote
SELECT *
FROM [GOSALES].[dbo].[Special Characters Test]
I am not facing any problem

Any ideas how can I overcome this issue using the column in my sql statement?

[MFGF]

Try including the column name in double quotes.

MF.

[sreejithhk]

Hi,
In cognos special character '?' refers to parameters. Any string enclosed inside a '??' will be considered as a parameter.

eg ?ParamName?

Thats the reason u get an exception.

Regards,
Sreejith H