"bala nemate" <bala.nemate@gmail.com> wrote in message news:grbpzmertzj6$.1kjgfx64oy991.dlg@40tude.net...
>>     CASE 
>>         WHEN K4.Id Is Not Null  THEN K4.Id 
>>         WHEN K3.Id Is Not Null THEN K3.Id
>>         WHEN K2.Id Is Not Null THEN K2.Id
>>         ELSE K1.Id END AS "priceId",
> 
> ne geriau tokį keisą keisti į COALESCE?

Aha labai i tema variantas :)