[thelist] ASP search

Joshua Olson joshua at alphashop.net
Wed Dec 12 11:31:59 CST 2001


Faye,

Something like this:

SELECT *
FROM my_table
WHERE manufacturer LIKE '%blah%'

The % are wildcards meaning any string, to include the empty string.  If you
want to search for records with blah in the beginning, use:

LIKE 'blah%'

For a search with the word at the end, use:

LIKE '%blah'

HTH,

-joshua

----- Original Message -----
From: "Faye Tarzwell (FayeC)" <ftarzwell at fayec.com>
Subject: [thelist] ASP search


: Hi,
:
: A friend needs to add a search to her boss' site.
<snip>
: Something like: "Select in Manufacturer for the word Western"
: I only know the statement for equals but not contains.....
:
: TIA,





More information about the thelist mailing list