Hi everybody,

Is there a DO CASE equavalent in Transact-SQL for procedural code, e.g.

CASE @PersonType = ' '
   One select statement
case ...
   Different select statement

etc.

Thanks in advance.

Creating different strings and using sp_executesql doesn't sound like a good approach to me. I'm guessing I need to use IF statements since there seems to be no CASE alternative for procedural code in T-SQL.