Re: -143 Error - Deadlock detected.

}>From ilist@rmy.emory.edu Tue Apr 15 16:20:02 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (940816.SGI.8.6.9/930416.SGI.AUTO) }> for <settler@dbintellect.com> id QAA22765; Tue, 15 Apr 1997 16:20:01 -0600 }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id PAA29404 for informix-list-out; Tue, 15 Apr 1997 15:15:01 -0400 (EDT) }>From: wmena@phoenixgroup.com }>Message-Id: <861128745.1112@dejanews.com> }>Subject: Re: LiveWire/Informix - Select question }>Date: Tue, 15 Apr 1997 13:32:35 -0600 }>Reply-To: Nils.Myklebust@idg.no }>Organization: Deja News Usenet Posting Service }>Sender: informix-list-owner@rmy.emory.edu }>To: informix-list@rmy.emory.edu }>X-Informix-List-Id: <news.36603> }> }>Try: }> }>database.SQLTable("select * from mytable where territory like '__98%'") }>(That's 2 underscores) }> }>Willy Mena }> }>In article <3351e48a.4420536@gate.idg.no>, }> Nils.Myklebust@idg.no wrote: }>> }>> You have got the direct answers on how to do this with Informix. }>> Now you might also want to redesign your database into what it should }>> look like as a relational database. There isn't supposed to be meaning }>> inside a code field. If territory and sales office aren't the same }>> thing (as they clearly aren't in your case) they should be in separate }>> columns. Then you can select on each, index each and so on. }>> }>> kjackson@lerc.nasa.gov (Keith Jackson) wrote: }>> }>> :Within a LiveWire app I have an Infomix table with a field called }>> :territory. The 3 and 4th characters of the territory are the sales }>> :office. I would like to do a select statement that can pull sales }>> :office off the territory field. }>> : }>> :For example: }>> : }>> :database.SQLTable(select * from mytable where }>> :substr(territory,2,2)='98') }>> : }>> :substr is NOT correct. Does anyone know (if it can be done) the }>> :correct syntax? I could use LIKE, but I need to pull out only the 3rd }>> :and 4th characters. }>> : }>> :Thanks in advance, }>> : }>> :Keith Jackson }>> :kjackson@vlib.com }>> }>> Nils.Myklebust@idg.no }>> NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway }>> My opinions are those of my company }>> The Informix FAQ is at http://www.iiug.org }> }>-------------------==== Posted via Deja News ====----------------------- }> http://www.dejanews.com/ Search, Read, Post to Usenet }> ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------