[thelist] ASP search

John Meyer johnmeyer_1978 at yahoo.com
Wed Dec 12 13:16:42 CST 2001


At 07:59 AM 12/12/2001 -0500, you wrote:
>Hi,
>
>A friend needs to add a search to her boss' site.
>The db has many fields such as "color", "width", "height",
>"manufacturer", "finish" (cabinet reseller).
>How would she need to add to select through a specific field for a
>specific word?
>Something like: "Select in Manufacturer for the word Western"
>I only know the statement for equals but not contains.....


standard SQL:

select <fields>|*(all fields) from <tablename> where <fieldname> = 
<searchterm>;






More information about the thelist mailing list