Yes, its for Sql Server and its working fine, thanks.

But, another issue is recods displying repeatedly, And i solved using 'Distinct' command.

Now i have one technical question, that if we issue a 'Distinct' to in front of a fieled it will
eliminate the repeatation of only the particular field or it will effect the entire query result.

Thanks a lot

Regards
Abdulla