I have a large table of data with descriptions that have been inconsistently entered. I'm trying to figure out how to include this field in a query and still group the records even if the descriptions don't match. In the example below I don't necessarily need the longest description, even if the result returns whatever description happens to be first that's fine. Thanks in advance!
SELECT PartNumber, Description, Sum(TotQtySold), year
GROUP BY PartNumber, Description, year
ABC123 |Repair Kit |5 |2007
ABC123 |kit |3 |2007
ABC123 |Repair kit |8 |2007
ABC123 |Repair Kit |16 |2007