On SDS Manager "All our SDS" page (require login) you can do free text search.

If you e.g. want to find all SDS in your library that contain the string "Alcohol resistant foam. Dry chemical powder", you open "Advanced search" and check "Free text search" option.

To search for an exact string, you can quote the string.  The result will show SDS that contains the exact string that you entered.