SQL Server 2012：选择文字并与Where中的文字进行比较

So, basically, in my query, I want to have a statuses column that will contain 1 or more statuses based on certain criteria. A user should be able to filter/search also on those status messages in that column. I'm not sure on the syntax to make this happen.So, basically, in my query, I want to have a st