[thelist] ASP search
Norman Beresford
n.beresford at anansi.co.uk
Wed Dec 12 07:26:27 CST 2001
Hiya Faye
"SELECT tableName.TableField" & _
" FROM tableName" & _
" WHERE tableName.TableField LIKE '%" & stringSearch & "%'"
HTH
Norman
> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Faye Tarzwell (FayeC)
> Sent: 12 December 2001 12:59
> To: Evolt
> Subject: [thelist] ASP search
>
>
> 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.....
>
> TIA,
>
> FayeC
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
>
More information about the thelist
mailing list