I currently have a table filled with Data for multiple days.
These dates are set as Columns within the data table and therefore i am required to unpivot the table to perform relevant queries.

What is the easiest way to select all columns beginning with `2020%`

I have used the following Q&A [Selecting all columns that start with XXX using a wildcard?](https://stackoverflow.com/questions/4797686/selecting-all-columns-that-start-with-xxx-using-a-wildcard) In order to create a separate Table with all the columns i require

```
SELECT [COLUMN_NAME]
FROM INFORMATION_SCHEMA.COLUMNS
WHERE [TABLE_NAME] = 'Table_Name'
AND [COLUMN_NAME] LIKE '2020%'
GO

```

However unsure how to use this secondary table to simplify my original question.