Path: utzoo!attcan!uunet!lll-winken!lll-tis!ames!sgi!wdl1!irddba
From: irddba@wdl1.UUCP (Sandy Darby)
Newsgroups: comp.databases
Subject: Re: Ingres question....
Message-ID: <3560018@wdl1.UUCP>
Date: 19 May 88 22:46:27 GMT
References: <22714@bu-cs.BU.EDU>
Lines: 23

</ wdl1:comp.databases / berlin@bu-cs.BU.EDU (David K. Fickes) /  4:21 pm  May 17, 1988 /
<Just a quick question for you Ingres hackers (RTI that is..)

Dave this is the query we discussed that converts the 3,4 position in
string to integer if the characters are in the range [0-9].

retrieve (table1 = int2(left(shift(table.fld1,-2),1) +                    
 left(shift(table.fld1,-3),1)))                                          
 where left(shift(table.fld1,-2),1) = "[0-9]" and                       
 left(shift(table.fld1,-3),1) = "[0-9]"   

IF you want to find the ones that are not there then:
 where left(shift(table.fld1,-2),1) != "[0-9]" and                       
 left(shift(table.fld1,-3),1) != "[0-9]"   

Good-Luck,
Carl P. Furner
Ford Aerospace Corp.
Western Development Laboratories

cpf@ford-wdl1.arpa
...{sgi,sun,ucbvax}!wdl1!cpf

All opinions stated here are my own, not my employer's.