Re: search function

Article View: alt.comp.databases.xbase.clipper

Article #17

Back to alt.comp.databases.xbase.clipper Previous Next

#17

From: LeemingIT
Date: Tue, 28 Sep 1999 00:00

18 lines
2023 bytes

Standard wildcards, I beleive, so it would be

    select * where my_column like "*<text>*"

I know this, because I often have to do a "manual" query in design view -
and in the criteria, one types

    Like "*dave*"

to search for dave.  I am not sure how you would parse the users' entry into
the SQL statement, though - would you
use this?

    select * where my_column like "*[forms]![Form Name]![User Text]*"

Any thoughts?

Tom Kelsall

Technical Details

Message-ID: <938536621.14505.0.nnrp-03.c1ed7c49@news.demon.co.uk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<7so02k$nau$1@bunyip.cc.uq.edu.au> <37EF8D80.2FC8B2EC@prodigy.net> <37F00D1E.6127A629@student.uq.edu.au> <37F0260D.307A45AA@student.uq.edu.au> <37F0E2F2.D4D03BCF@prodigy.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f469f,1aaba471388bd669
X-Google-Attributes: gidf469f,public
X-Google-Thread: ff0ac,1aaba471388bd669
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10b2b7,1aaba471388bd669
X-Google-Attributes: gid10b2b7,public
X-Google-Thread: 106b3c,1aaba471388bd669
X-Google-Attributes: gid106b3c,public
X-Google-Thread: 104de1,1aaba471388bd669
X-Google-Attributes: gid104de1,public
X-Google-Thread: fc5c9,1aaba471388bd669
X-Google-Attributes: gidfc5c9,public
X-Google-Thread: f6611,1aaba471388bd669
X-Google-Attributes: gidf6611,public
X-Google-Thread: ff4b7,1aaba471388bd669
X-Google-Attributes: gidff4b7,public
From: "LeemingIT" <ITManager@LeemingIT.demon.co.uk>
Subject: Re: search function
Date: 1999/09/28
Message-ID: <938536621.14505.0.nnrp-03.c1ed7c49@news.demon.co.uk>
X-Deja-AN: 530347531
X-NNTP-Posting-Host: leemingit.demon.co.uk:193.237.124.73
References: <7so02k$nau$1@bunyip.cc.uq.edu.au> <37EF8D80.2FC8B2EC@prodigy.net> <37F00D1E.6127A629@student.uq.edu.au> <37F0260D.307A45AA@student.uq.edu.au> <37F0E2F2.D4D03BCF@prodigy.net>
X-Trace: news.demon.co.uk 938536621 nnrp-03:14505 NO-IDENT leemingit.demon.co.uk:193.237.124.73
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: alt.comp.databases.xbase.clipper,bit.databases.mssql-l,comp.databases,comp.databases.adabas,comp.databases.btrieve,comp.databases.filemaker,comp.databases.ms-access,comp.databases.ms-sqlserver,comp.lang.basic.visual.database,microsoft.public.vb.d
X-Complaints-To: abuse@demon.net

Reply to Parent Message