thanks. tried to download BOL but realized it was already installed!
found it in there




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