This question is with regard to creating views in SharePoint.
I am trying to create a view on SharePoint list where i want a filter to select only those rows where Department is equal to E&TC but it's not happening.
It's because of '&' sign.
Also it's indexed column so i cannot apply "begins with"
How to filter such values using Views in SharePoint?