BO report file SQL 1

[kalkalai]

Hi,

I copied BO .rep file SQL script to directly query the db...
my query does not execute since it cannot undestand the below written script part

select substring("0", sign(sum(dbo.ABC)), 1)...

it says that it cannot find column named "0", plz can you help me? Thanks in advance!

 

[skrandel]

Did you parse the SQL from within BO?

If you had, you likely would have found that it was wrong there? Try replacing the double quotes with single quotes first and then see.

However, I don't understand this statement. Why are you substringing a single value?

Steve Krandel
Intuit

 

[kalkalai]

I substituted it with single quotes itis ok...

thanks a lot...