Re: SQL Select with *name* search - Article 608 - go-pugleaf

Article View: borland.public.delphi.database.dotnet

Article #608

Back to borland.public.delphi.database.dotnet Previous Next

Re: SQL Select with name search

#608

From: Jon Kaumheimer
Date: Tue, 09 Nov 2004 15:17

20 lines
1556 bytes

"Hans" <info@tct.nl> wrote in message
news:418df585@newsgroups.borland.com...
> I like to select based on a part of the nametext in SQL database fields.
> With the SQL select you can something like:
>
> Select * From persons where name>=@name
> parameters  @name = 'Jack'
>
> But I like to do a Select with
>
> Select * From persons where name=@name
> parameters  @name = '*ack*'
>
> Is that possible? With the LIKE it doesn't work.
> Anybody suggestion?
>
> Hans
>
>

Technical Details

Message-ID: <4190deed@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.zanker.org!news.cambrium.nl!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!news-hub.cableinet.net!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <418df585@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effe6,358a64acbbbea008
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Jon Kaumheimer" <joen_kaumheimer@hotmail.com>
From: "Jon Kaumheimer" <joen_kaumheimer@hotmail.com>
Newsgroups: borland.public.delphi.database.dotnet
References: <418df585@newsgroups.borland.com>
Subject: Re: SQL Select with *name* search
Date: Tue, 9 Nov 2004 16:17:54 +0100
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 81.216.10.3
Message-ID: <4190deed@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1100013293 81.216.10.3 (9 Nov 2004 07:14:53 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.zanker.org!news.cambrium.nl!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!news-hub.cableinet.net!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message