StringBuilder sb = new StringBuilder(); sb.Append("SELECT *"); sb.AppendFormat(" FROM {0}",YourTableName); sb.AppendFormat(" WHERE cName LIKE '{0}%'", WorkGroup); sb.AppendFormat(" AND dIntervalStart >= '{0}' AND dIntervalStart < '{1}'", StartDate, EndDate); sb.Append(" GROUP BY cName"); string sql = sb.ToString(); SqlConnection cn = new SqlConnection(SqlDataSource); SqlCommand cm = new SqlCommand(sql, cn);