how to do boolean on sql server ssms table filter

In SQL Server, one normally uses the terms "AND" and "OR".  
I am not exactly what you are trying to accomplish with your "UTM||Hourly."  Are you saying that you want to test a column in a table for either "UTM" or "Hourly" and not return any columns that do not test True or return all rows and then actually filter those rows on the CLient side to restrict the display to the rows with those values.
In other words, are you rally wanting to filterthe rows after the fact or constrain the selection of rows at the time of selection?

I meant to use UTM||Hourly to mean
UTM OR Hourly
in this case specifically i went
if tablename not containing UTM OR Hourly
then show

I don't think MS has allowed for that usage.  You will probably have to filter on each separately or figure out how to filter out the rest of the tablenames.  Is there a common element in the names you do not want to see that also does not appear in the names you do want to see?