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?
Try including the column name in double quotes.
MF.
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