>how do you do this in sqlserver:
>

>SELECT IIF(active,"\"+code,code) as code,title,statute_id FROM statute ORDER BY 1
>
>

>use for enabling/disabling items in combobox
>
>thanks
>
>Peter

You can use CASE in a select statement. Look in Books Online for CASE.