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