>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.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________