I want to make the Note field filterable in a data grid as you see in the image, after reviewing the InventClosing table I noticed that the Notes field is a Memo string type (nvarchar(MAX)). As far as I know this type of field is not recommended to be filterable however the client has requested that this field be filterable in the grid !
Could you please advise how I can make this type of field filterable,or if there is a recommended approach to achieve this?
Thank you.

Report
All responses (
Answers (