Thanks very much Sergey.

>Hi Terry,
>
>The iif() and isempty() functions are from SQL Server Analysis Services ( Data warehouse). In regular select IIF can be replaced by CASE function and isempty() by LEN(RTRIM(LTRIM(str))) = 0 or str = SPACE(nn).
>
>
>>The example give error near =
>>If I replace the month expression with true I get iif is not a function when
>>it is in books online with a similar example using isempty inside the iif()
>>When I try that I get error: isempty is not a function.
>>

>>
>>select count(1), count(iif(month(registerdate)=1,1,0)) from registerfrom
>>
>>select count(1), count(iif(isempty(registerdate),1,0)) from registerfrom
>>
>>

>>
>>Any ideas?