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

[Edgar Luna]

"Brian Johnson" <address@hidden> writes:

> Found out something today.  pgsql, mysql, and mssql all support the CASE 
> statement
> in sql

> It might be good to keep the code as standard as possible (even though we are 
> using
> the db specific concat functions, someday they might merge on one standard) 
> and use
> the CASE function instead of COALESCE() or ISNULL() or IFNULL()

> http://www.postgresql.org/docs/7.2/interactive/functions-conditional.html
> http://www.mysql.com/doc/en/Control_flow_functions.html
> http://dbforums.com/t907538.html
Ok, I'll read more on it, tomorrow.

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

Thanks a lot Brian

-- 
Edgar Antonio Luna Díaz - http://www.sogrp.com
Fingerprint: C008 5EAC 5272 AC8C 7589  4821 8B34 6166 8733 8310