sql expressions

[syncdba]

Hi,
Is it possible to use the following sql query in sql expression?.I tried it but giving errors:

select id,accountid,
case when "sfdcOpportunity"."ISP_Complete_Account_Plan__c"='true'
then 'Complete_Account_Plan : COMPLETED'
else 'Complete_Account_Plan '
end as Complete_Account_Plan,
case when "sfdcOpportunity"."ISP_Determine_Partner_Plan__c"='True'
then 'ISP_Determine_Partner_Plan : COMPLETED' else 'ISP_Determine_Partner_Plan '
end as ISP_Determine_Partner_Plan,

 

[lbass]

From previous posts, I believe you are using CR XI. You should be creating queries like this in database->database expert->your datasource->Add Command.

-LB