SQL Select with *name* search - Article 606 - go-pugleaf

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

Article #606

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

SQL Select with name search

#606

From: Hans
Date: Sun, 07 Nov 2004 10:13

15 lines
1267 bytes

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: <418df585@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.wirehub.nl!194.72.7.126.MISMATCH!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effe6,358a64acbbbea008,start
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Hans" <info@tct.nl>
Newsgroups: borland.public.delphi.database.dotnet
Subject: SQL Select with *name* search
Date: Sun, 7 Nov 2004 11:13:02 +0100
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 213.10.69.25
Message-ID: <418df585@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1099822469 213.10.69.25 (7 Nov 2004 02:14:29 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.wirehub.nl!194.72.7.126.MISMATCH!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail