Re: [Phpgroupware-developers] Contact function for SQL (howto in mssql)

[Admin]

>
>> Example:
>> SELECT a,
>> CASE WHEN a IS NOT NULL THEN a
>> ELSE ''
>> END
>>>FROM test;
>Not sure if this is exactly the same for mssql.
>

it is the same, and there doesn't seem to be much, if any, performance 
difference
even on 170,000 rows against an non-indexed field.

I don't yet have a phpgw running against an MSSQL server but I do write code on 
one
every day so i can help with any syntax stuff you're not sure about.