Some info about my project.. I am designing a system for my company.. my compnay has many contractors. so i have a field in my database called contractors. In a point i need to retrieve how many different kinds of contractors are there from my database . So there should not be any repetition. is there any way i can achieve this in a select statement????