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