Hello ! ColdCoffee

Thanks for the attempt you have made but the out put is not what I want, I have send an image attachment with this message , there you will find the execution result for the query you have send, if you go to the Result section , under the orderyear field the O/P is coming like cnt2007,cnt2008.... like that;

I want to omit this cnt portion, if you have any suggestion then please sent me by tomorrow.

I think I have made it clear.

*** I have also a solution but I want to discuss it after I get any better answer from anyone.

Thanks once more.

Subhro