Hi gandolf989,

Thanks for you suggestion.

I have mix value in any case, so i have to make use of upper.

Second thing is nvl and decode i can remove that, but my question is Grouping the resultset an then compare the quantity is that OK or we can write the same query some other efficient way.

With Regards

Hitesh Parikh