>SELECT iif(isempty(field1),0,1) as myfield FROM mytable
>
>I want to use IIF and isempty in SQL 2000

Hi Mike,

Sergey has given you the right answer. You can find answers to all your syntax needs < g > in the Microsoft SQL Server Books Online downloadable from the SQL Server web pages.