Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <jcasale@activenetwerx.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.039
X-Spam-Evidence: '*H*': 0.92; '*S*': 0.00; 'shipped': 0.05; 'subject:version': 0.09; 'wrapped': 0.09; 'received:172.18.0': 0.16; 'sqlite': 0.16; 'subject:sqlite3': 0.16; 'thanks,': 0.17; 'this?': 0.23; "doesn't": 0.30; 'anyone': 0.31; 'but': 0.35; 'version': 0.36; 'charset:us-ascii': 0.36; 'to:addr:python-list': 0.38; 'to:addr:python.org': 0.39; 'received:unknown': 0.61; 'utilize': 0.61; 'within': 0.65; 'utilized': 0.84
X-Cloudmark-SP-Filtered: true
X-Cloudmark-SP-Result: v=1.1 cv=aTVRNjW1y6NjoOpVf0TT9V0PHXDfZZQvid8DyjJaX1w= c=1 sm=1 a=CRTDazI5n6YA:10 a=7PYXob_7ZXMA:10 a=BLceEmwcHowA:10 a=kj9zAlcOel0A:10 a=xqWC_Br6kY4A:10 a=oNw28mxuUhXRB3mVwYQ4Ag==:17 a=8VrocDcF-ZtbKEHrSLQA:9 a=CjuIK1q_8ugA:10 a=W030dhmSI9wA:10 a=m19lIRtctqEA:10 a=HpAAvcLHHh0Zw7uRqdWCyQ==:117
From: "Joseph L. Casale" <jcasale@activenetwerx.com>
To: "'python-list@python.org'" <python-list@python.org>
Subject: sqlite3 version lacks instr
Thread-Topic: sqlite3 version lacks instr
Thread-Index: Ac6LwHRBW97hVOVST0KljPrA4kt7Kg==
Date: Sun, 28 Jul 2013 18:32:28 +0000
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
x-originating-ip: [172.18.0.200]
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.5198.1375036433.3114.python-list@python.org>
Lines: 8
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1375036433 news.xs4all.nl 15991 [2001:888:2000:d::a6]:36417
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:51395

I have some queries that utilize instr wrapped by substr but the old
version shipped in 2.7.5 doesn't have instr support.

Has anyone encountered this and utilized other existing functions
within the shipped 3.6.21 sqlite version to accomplish this?

Thanks,
jlc