[TIP] Use COALESCE instead of nested IFNULL calls.

[Ruslan Zasukhin]

On 3/15/05 2:40 PM, "jda" <jda at his.com> wrote:

> 
> Hi Ivan,
> 
> I tried this select:
> 
> s = "select *,theDateSortMethod,COALESCE(authors, editors, title) as
> 'ff' from thereferences where hit>0 ORDER BY ff,theDateSortMethod"
> 
> and got the error:
> 
> Feature Not Supported

This is because ORDER BY  ff present here, Jon.

Remove ORDER BY to see how works COALESCE


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------