[sqlite] Re: collation - order null values to end of result

[Igor Tandetnik]

ecc <[EMAIL PROTECTED]> wrote:

select
*
from
files
left join meta_data on files.id=meta_data.id
order by
meta_data.title asc,
files.title asc

How can i change the collation sequence to get num -> string -> null?

order by
   сase typeof(meta_data.title)
       when 'integer' then 0
       when 'real' then 0
       when 'string' then 1
       else 2 end,
   meta_data.title,
   files.title

Igor Tandetnik