Hi,

I am porting a report from another reporting platform and was having problems.  Below is a simplified query (Oracle) similar to the actual query I am trying to port to SSRS.

select @test
from dual
where to_number(@test) = to_number(@test)

When running the above through the Design a query I get this:

ORA-00936: missing expression
ORA-00936: missing expression

It does not like the condition in the where clause.  Anyone got any idea on how to formulate this to work?

Let me know.

Thanks.

Tony

​Hi, I am porting a report from another reporting platform and was having problems.  Below is a simplified query (Oracle) similar to the actual query I am trying to port to SSRS.select @testfrom dualwhere to_number(@test) = to_number(@test)When running the above through the Design a query I get this:ORA-00936: missing expressionORA-00936: missing expression It does not like the condition in the where clause.  Anyone got any idea on how to formulate this to work?Let me know. Thanks. Tony  Read More

​