on 04-06-2016 11:54 PM
Hi folks
I have SQL script code need to transfer to CE function
the sample code is
select xx, xx, xx, xx,
(case when a.X1 = 'xx' then 'xxxxx'
when a.S1 is null then ''
when b.M is null then a.S1
else a.S1|| ' - ' || b.M end) as CA_LV
from Table A as a
left outer join
Table B as b
You can see, in the calculated column
there are multiple "when...then" and "else" statement
I want know how can this be transferred to CE function
Is function CE_CALC() working for more than one "when...then" statement?
Can anyone convert the sample code to CE function?
Thanks
Hi,
Why would you want to use CE functions? These are obsolete and should not be used anymore.
Anyhow, assuming that you need to test something with CE function you can use if clauses on CE_CALC, like shown here.
BRs,
Lucas de Oliveira
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.