>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.

No. T-SQL CASE is used in a select statement to conditionally evaluate field results.

IF..ELSE is ugly but it does work.