Re: Tricky SQL

Article View: borland.public.interbase.sql

Article #10982

Back to borland.public.interbase.sql Previous Next

#10982

From: Ronny Bengtsson
Date: Thu, 02 Jan 2003 15:03

27 lines
1632 bytes

Amita,

Thanks, the partnumber can of course have different length but I think this 
could be solved with the POS function. 
You have shown me on the track.

I will try this.

/Ronny


"amita" <amita@agnisoft.com> wrote in
news:3e13c922@newsgroups.borland.com: 

> Try
> 
> Select * FROM Table1 C
> where cast(getSubStr(c.PN,1, 3)||getSubStr(c.PN,5, 4) as
> Integer)>=1234567 and
> cast(getSubStr(c.PN,1, 3)||getSubStr(c.PN,5, 4) as Integer)<=1234599
> 
> where getSubStr is a UDF to get the substring
> 
> --
> Amita
> Agnisoft
> www.agnisoft.com

Technical Details

Message-ID: <Xns92F7A34DBED16ronnybengtssonrobese@207.105.83.65>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newshosting.com!news-xfer1.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<Xns92F69DA62D2AFronnybengtssonrobese@207.105.83.65> <3e131ffe$1@newsgroups.borland.com> <Xns92F6EC38DAE0Cronnybengtssonrobese@207.105.83.65> <3e13c922@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,99de7b04b7abe7f7
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2003-01-02 07:12:11 PST
Newsgroups: borland.public.interbase.sql
Subject: Re: Tricky SQL
From: Ronny Bengtsson <Ronny_Bengtsson@hotmail.com>
References: <Xns92F69DA62D2AFronnybengtssonrobese@207.105.83.65> <3e131ffe$1@newsgroups.borland.com> <Xns92F6EC38DAE0Cronnybengtssonrobese@207.105.83.65> <3e13c922@newsgroups.borland.com>
Organization: ROBE
Message-ID: <Xns92F7A34DBED16ronnybengtssonrobese@207.105.83.65>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: 213.67.226.253
Date: 2 Jan 2003 07:03:11 -0800
X-Trace: newsgroups.borland.com 1041519791 213.67.226.253 (2 Jan 2003 07:03:11 -0800)
Lines: 27
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newshosting.com!news-xfer1.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message