If you can't have two : after each other then this should work:
SELECT LTRIM(LTRIM('abc:xyz',REPLACE('abc:xyz',':','')),':')SELECT LTRIM(LTRIM(Field1,REPLACE(Field1,':','')),':') FROM Table1 -- View this message in context: http://old.nabble.com/Substring-question-tp31924687p31928255.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
