Article View: borland.public.interbase.sql
Article #11150Re: LIKE operator
From: Bill Todd
Date: Tue, 03 Dec 2002 22:24
Date: Tue, 03 Dec 2002 22:24
28 lines
1692 bytes
1692 bytes
If you are looking for a field that begins with a string of characters the best choice is: SELECT * FROM SOME_TABLE WHERE SOME_FIELD STARTING WITH 'ABC' If you want ABC anywhere in the field use: SELECT * FROM SOME_TABLE WHERE SOME_FIELD LIKE '%ABC%' On Tue, 3 Dec 2002 18:19:53 -0300, "Sergio Perdichizzi" <sperdich@reliable.com.ar> wrote: >Hello. >Can anyone give me a good example on how to use the LIKE operator in >interbase SQL? >I think it's used for something I need to do, but I can't make it work. >I need to select a VARCHAR field when the value begins with a string set. >Thanks a lot. > >Sergio > -- Bill (TeamB) (TeamB cannot respond to questions received via email)
Technical Details
Message-ID:
<rkbquuc7fajnf65016tkts9ct5uhg5sfm7@4ax.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!nnxp1.twtelecom.net!logbridge.uoregon.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3ded2091@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 114a0e,446ceb04e409b45b X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-12-03 14:27:14 PST From: Bill Todd <bill@notthis.dbginc.com> Newsgroups: borland.public.interbase.sql Subject: Re: LIKE operator Date: Tue, 03 Dec 2002 15:24:01 -0700 Message-ID: <rkbquuc7fajnf65016tkts9ct5uhg5sfm7@4ax.com> References: <3ded2091@newsgroups.borland.com> X-Newsreader: Forte Agent 1.91/32.564 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 216.207.211.30 X-Trace: newsgroups.borland.com 1038954244 216.207.211.30 (3 Dec 2002 14:24:04 -0800) Lines: 28 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!nnxp1.twtelecom.net!logbridge.uoregon.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail