>How would I best do something like this in T-SQL?
>
>SELECT IIF(ISNULL(int_field),0,1) AS lSelected FROM MyTable
>
>Do I use a SQL CASE statement, or is there an easier in-line way?
>
Yes, you'll use CASE function

CASE WHEN int_field IS NULL THEN 0 ELSE 1 END AS ...