Thank you for reaching out on the Redgate forums regarding the SQL Search question.
I can see that the Boolean search capabilities were added back in version 2 of the program.
Then in version 3.1 the functionality was removed/modified to use UNIX-style wildcards instead.
I've located the following notes on the usage of these wildcards which may be of use for you.
SQL Search is compatible with UNIX style wildcards. You can use the following wildcards in a search: Asterisk (*) wildcardYou can use * as a wildcard to match 0 or more characters, similar to a SQL LIKE clause.For example, search for 'b*' to find all objects containing words beginning with b. Question mark (?) wildcardThe ? wildcard to matches exactly one character.For example, search for 'b?' to find all objects containing words of two characters beginning with b. List () wildcardThis  wildcard matches one character from a list of characters.For example, search for '[xyz] ' to find all objects containing any single x, y, or z character.This wildcard also allows a range of characters. For example, search for '[a-z]' to match any single character from a to z. Caret (^) wildcardYou can use ^ as a wildcard at the beginning of a list to match any character except any character in the list.For example, search for '[^0-9]' to match any single character except a numeric character. Escaping wildcards"If you want to search for a wildcard as a literal character, you can escape the wildcard character by wrapping it in square brackets.For example, searching for '[*]' will search for anything containing an asterisk
Apologies that the Boolean operations are not there, but hopefully you are able to find value in these wildcards instead.
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal