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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users