Tricky SQL

Article View: borland.public.interbase.sql

Article #10964

Back to borland.public.interbase.sql Previous Next

#10964

From: Ronny Bengtsson
Date: Wed, 01 Jan 2003 14:29

15 lines
1132 bytes

Hi,

Happy New Year everyone.

I have needs for a SQL query that use both LIKE with wildcards % and 
BETWEEN.or IN

Example

Select * FROM Table1 C
WHERE  C.PN BETWEEN(LIKE '101%381015%9', LIKE '101%381015%99')

Anyone that have any ideas?

/Ronny

Technical Details

Message-ID: <Xns92F69DA62D2AFronnybengtssonrobese@207.105.83.65>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer01.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,99de7b04b7abe7f7,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2003-01-01 06:38:46 PST
Newsgroups: borland.public.interbase.sql
Subject: Tricky SQL
From: Ronny Bengtsson <Ronny_Bengtsson@hotmail.com>
Organization: ROBE
Message-ID: <Xns92F69DA62D2AFronnybengtssonrobese@207.105.83.65>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: 213.67.226.253
Date: 1 Jan 2003 06:29:48 -0800
X-Trace: newsgroups.borland.com 1041431388 213.67.226.253 (1 Jan 2003 06:29:48 -0800)
Lines: 15
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer01.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail