[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