Hi,
the following seems wrong to me:
bash-4.0# sqlite3
SQLite version 3.6.14.2
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select ltrim("12300567","1230");
567
sqlite> select ltrim("012300567","0123");
567
sqlite> select ltrim("12300567","123");
00567
sqlite>
Is the stripping of leading 0's intentional?
(or a bug in my netbsd port?)
How can I workaround this problem?
cheers thilo
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users