I have a stored procedure that may or may not get a string list of int ids. When it doesn't get it the value is: ' '. Other wise its something like this: '500,507,908'

I'm trying to use it like this:

```
select ID as projectTeamId, Employee_ID, Supervisor_ID 
from ProjectTeam 
where Project_ID = @projectId and IsDeleted = 0 and 
        ID in (CASE @stringList WHEN '' THEN ID ELSE (SELECT * from TurnListStringIntoTable(@stringList)) END)

```

to get a result set but it errors out with this code when the string list comes in blank:

> 
> An error has occurred while processing Report 'MassReleaseHoursReport':
> Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
> 
> 
> 

I know its an issue where id needs to = id instead of being in id. Any ideas on how I can have the case statement work with @stringList = '' then id = id else id in (SELECT \* from TurnListStringIntoTable(@stringList))?

TurnListStringIntoTable returns a table from a string list which in my case is just the project Team ID