Hi Joshua,

In reply to:

> The real issue I'm trying to solve is a sorting one. I run some SQL which 
> takes some integers and creates a column for sorting with data like 
> following:
> 1.1.2.3
> 1.2
> 1.12.4

Why not do something like:

select Column1 || '.' || Column2 || '.' || Column3 || '.' || Column4
from MyTable
order by Column1, Column2, Column3, Column4
;

Tom
BareFeetWare

 --
Comparison of SQLite GUI tools:
http://www.barefeetware.com/sqlite/compare/?ml



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to