Untitled

WITH RankedRows AS (
  SELECT NrProjektu + '-' + Firma as ind, NazwaOdbiorcy,
         ROW_NUMBER() OVER (PARTITION BY NazwaOdbiorcy ORDER BY NrProjektu) AS RowNum
  FROM WASKO_DAX2009_PROD.dbo.Projekty2JIRA
)
SELECT ind, NazwaOdbiorcy
FROM RankedRows
WHERE RowNum = 1 AND lower(NazwaOdbiorcy) like concat(lower(?),'%') ORDER BY NazwaOdbiorcy ASC