Richard Hipp wrote: > On Thu, Mar 6, 2014 at 3:41 PM, Walter Hurry <walterhu...@gmail.com> wrote: > >> A small enhancement request: >> >> It would be great if the RPAD and LPAD functions could be implemented in >> sqlite. >> > > The SQLite you can get the effect of RPAD(x,y) using PRINTF('%-*s',y,x). > See http://www.sqlite.org/lang_corefunc.html#printf for details.
Thanks, but you snipped the relevant part of my post: "I know I can easily achieve the equivalent ... but if the functions were available natively it would avoid the need to hack third party SQL scripts." _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users