How to put multiple string values in one parameter
I have a table of text status codes. I need to create a parameter that would join some of these codes into one, such as a parameter that would contain all statuses that begin with the letters "O" and "R". How would you create something like this?
I'm looking at using a function and I'm using SQL 2014. The current parameter looks something like this: AND @ClaimStatus = HT.ClaimStatus) I need to declare @ClaimStatus to do something like "@ClaimStatus in ('O%' or 'R%') so that it will already be populated with all statuses beginning with "O" or "R."