Search by Fine Waive Note

SELECT *
  FROM [Polaris].[Polaris].[PatronAccount]
  where FreeTextNote like '%NOTE-TEXT%'

You’d need to join in POLARIS.POLARIS.PolarisUsers to get the username.

You can also get a different view using: Get Information About Patron Account Waives