Select Case Statement

[dianemarie]

Hello, I have two parameters. First one (@ByOwnLst) has two options "owner" and "list". The second parameter (@OwnLst) runs the report by owner or list number, depending on the choice selected in the @ByOwnLst parameter. In my Where statment I have the following, which returns the error: incorrect syntax near the word 'IN'. I've tried it several different ways. Any help would be greatly appreciated. Thank you.

Where
Case
When @ByOwnLst = 'Owner' then lo.owner in (@OwnLst)
Else lo.lnum in (@OwnLst)
End

 

[RiverGuy]

Try this:

WHERE
(@ByOwnLst = 'Owner' AND lo.owner IN (@OwnLst)
OR
(@ByOwnLst <> 'Owner' AND lo.lnum IN (@OwnLst)