Combining MSSQL Functions and Wildcards to Filter Data

We can combine SQL functions and use "LIKE" to filter data searching a string in a column. We are not using RegEx, just simple pattern matching. Here's our practical example.

We are given a table called "CityYear" with a column, "Title" that has this pattern "[city name] ([year])", e.g.;

Let's say we just want to pull the rows containing data for the current year only (2018 at the time of this post).

The first attempt could look like this:

However this returns no results. This is because we are matching to a string that literally contains "+ YEAR(GETDATE() ) +". Trying the following:

Gives us an error: Conversion failed when converting the varchar value '%' to data type int.

The above query returns exactly what we want:

The following query narrows down possible variations even more by conforming to the pattern and adding parenthesis to the comparison parameter.

If we want to find the previous year (in this case, 2017), we subtract from the YEAR(GETDATE()) function.