TM1 Forum

Hi all,
I have a column that its name contains a special character for example Product? (the name of the column contains the quenstion mark)
when I wrote in TM1 process
SELECT [Product?]
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 should I write the sql statement to include the Product? column?

You need to change the name of your Product? dimension because this is going to cause you problems. The "?" character is used in the TM1 for variable subsitution in your SQL string so you can have an SQL query that is dynamic, based on an input parameter in a TI process.