Jason Selburg (10/25/2013)

---

You're looking for the FIRST_VALUE function.

DECLARE @testData TABLE

([Industry] VARCHAR(2)

,[Naicstitle] VARCHAR(50)

,[NumMatch] INT)

INSERT @testData (Industry,Naicstitle,NumMatch)

VALUES

('00', '', 1025)

...