[Trac] Re: custom fields in reports

[Joe]

Jim Cheetham wrote:
> However, it didn't do quite what I expected ...
>    IFNULL(c.value,0) AS chargeable
> made the whole column return as numeric - including the existing fields
> that have values like "15m" appearing as "15.0". IFNULL(c.value,"no")
> didn't help either.

I'm not that familiar with SQLite so I can't say if that's a bug or not, but 
just in case you literally used double quotes, I should point out that 
(generally) SQL implementations prefer literal character values enclosed in 
single quotes, i.e., IFNULL(c.value, 'no').

Joe