You can use condition such as
IF(LEFT([COL NAME],n) == "pattern", true statmt, false stmt).
The left function would fetch n characters from left i.e, starting n characters from the text in your column.
Use the column in the filter and go to advanced and select starts with and then display the data.
Hope it helps you.