I’m trying to find the first SeqGrp and SeqNum of the first unique values TaxGroupCode. I had this query in a MSACCESS query (Shown below), but we recently started using SQL 2008 instead. However, it seems “FIRST” isn’t a valid function in SQL (at least in this version).

SELECT DISTINCT First(DesotoCoPA_Trims.SeqGrp) & “-” & First (DesotoCoPA_Trims.SeqNum), “Tax District ” & DesotoCoPA_Trims.TaxGroupCode As Sample
FROM DesotoCoPA_Trims
GROUP BY DesotoCoPA_Trims.TaxGroupCode;