Hi List Here's basically what I'm doing:
sqlite> create table test(t text); sqlite> insert into test values(0123); sqlite> select * from test; 123 How can I get the string to stay 0123? I've read the docs about "Column Affinity." But I guess I'm not smart enough to figure this out :-) BTW, I can't put the number into quotes first because that would break my code, at a later point, when I handle this value. IE, the user could insert '0123' (string) or 0123 (number). I need these to stay unique. Thanks in advance for any guidance! -Sean _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users