Thanks Michael, that solves the problem.
Pete
Message: 1
> Date: Sun, 26 Jun 2011 12:01:43 +0000
> From: "Black, Michael (IS)" <michael.bla...@ngc.com>
> Subject: Re: [sqlite] Substring question
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Message-ID: <71635118-DC41-416E-AE85-F788177BBC96@mimectl>
> Content-Type: text/plain; charset="iso-8859-1"
>
> It's not obvious but this works
>
>
>
> CREATE TABLE x (s string);
> INSERT INTO "x" VALUES('ab:cdef');
> INSERT INTO "x" VALUES('ghij:klmn');
> sqlite> select
> ltrim(ltrim(s,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'),':')
> from x;
> ltri
> ----
> cdef
> klmn
>
> Just make sure your char set contains all possible chars left of the :
>
>
>
>
>
> Michael D. Black
>
> Senior Scientist
>
> NG Information Systems
>
> Advanced Analytics Directorate
>
>
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
