John Salerno wrote:

So why didn't it expand for Programmer II, but it does expand for AA?

AIUI, the default column width is the greater of 10 and the width of the first line of output.

sqlite> .mo co
sqlite> .he on
sqlite> create table t(t TEXT UNIQUE);
sqlite> insert into t(t) values("aaaaaaaa");
sqlite> insert into t(t) values("bbbbbbbbbbbb");
sqlite> insert into t(t) values("cccccccccccccccc");
sqlite> select * from t;
t
----------
aaaaaaaa
bbbbbbbbbb
cccccccccc
sqlite> select * from t order by t desc;
t
----------------
cccccccccccccccc
bbbbbbbbbbbb
aaaaaaaa
sqlite>

Martin

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to