CASE Statement use in Select Statement

[ishfaqad]

Dear All,

Can we Use CASE Statement in SQL Query while "Creating View" with "SQL Query"...i.e...

SELECT v.FianaceYear, v.FinanceMonth ,FT.FinanceType_Eng, M.Description_en

,CASE WHEN v.tContractStatusId =3 and v.IsWriteOff IS NULL THEN 'Termianted'
WHEN v.tContractStatusId =3 and v.IsWriteOff=1 THEN 'Write Off - Termianted'
WHEN v.IsExpired =1 and v.IsWriteOff IS NULL THEN 'Expired'
WHEN v.IsExpired =1 and v.IsWriteOff=1 THEN 'Write Off - Expired'
WHEN v.tContractStatusId=1 and v.IsExpired =0 and v.IsWriteOff=1 THEN 'Write Off - Current'
ELSE 'Current' END ContractStatus
........


if we can use CASE in select statement...please help

[RADSr]

Yes - I just tested using this;

select

    *

, CASE 

    WHEN Name = 'Jane' THEN 1 ELSE 2 END as CASEME

from

    _Rounding.rounding_csv

and it worked fine via SPARK SQL.

[RADSr]

Also w/ Postgres SQL   

[RADSr]

But really, if you want to use SQL to build an Incorta view use the derived table => Incorta SQL option.   It's speedy.