Hi,

The above query also takes both the CASE statements.

Where as it should take only one case and if 1st case is NULL only then it should go for 2ns CASE