[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