Re: joining 2 queries
From: Ken Denny <ken_at_kendenny.com>
Date: Fri, 25 Jan 2008 11:24:14 -0800 (PST)
Message-ID: <c6ca22e2-4823-4670-b41e-a7efd9f88360@i7g2000prf.googlegroups.com>
Date: Fri, 25 Jan 2008 11:24:14 -0800 (PST)
Message-ID: <c6ca22e2-4823-4670-b41e-a7efd9f88360@i7g2000prf.googlegroups.com>
In addition to Charles's excellent idea, let me add a note:
On Jan 24, 7:38 pm, Totti <saliba.toufic.geo..._at_gmail.com> wrote:
> and mod(substr(suppl,7,1),1 ) = 0
any number mod 1 is 0. Assuming that suppl is always 7 characters and the 7th character is always numeric, what you want is
and mod(substr(suppl,7,1),2) = 1
Of course if you had the case where the seventh character was not numeric you'd get an error. A better way might be
and substr(suppl,length(suppl),1) in ('1','3','5','7','9') Received on Fri Jan 25 2008 - 13:24:14 CST