Filter support for LIKE and NOT LIKE?


In SQL Compare, in the Filter setup you can use LIKE and NOT LIKE criteria, however in SQL Source Control (i.e. the SSMS add-in), it seems to be missing those occasionally useful options.

Is there any reason why or am I overlooking something?



  • Options
    Hi @BugmeisterThe "Contains" option in the dropdown filter rules behaves the same as SQL Compares LIKE as does the "Does not contain" behaves the same as the SQL Compare NOT LIKE option. This allows you to use the wildcard (%) character. 

    Hope this helps!

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our 
    Help Center?

Sign In or Register to comment.