Re: HELP ASAP: SQL wild card question

Subject: Re: HELP ASAP: SQL wild card question
From: Peter <pnewman1 -at- home -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Thu, 16 Aug 2001 08:02:15 -0400

"Cook, Jenise" wrote:
>
> _Bottom line:_
> Do you recognize the asterisk (*) as "the" universal wild card in Web and
> application search engines?
>
> _My Story:_
> We have a new Web application (internal users) with fairly dynamic search
> capabilities. Today, we just found out from one of the programmers that the
> % symbol is the SQL search wild card for our application. We found out
> because a user tried to search on company names by entering [ *& Sons ], and
> it didn't work. The programmer says the search should be [ %& Sons ].
>
> The Program Manager is asking me to communicate the % wild card entry to our
> users. (Although internal, our users number several hundred, and are
> scattered across the U.S.) I'm about to send an e-mail requesting that they
> change the % wild card to an asterisk.
>
> I haven't taken a SQL class, yet. Before I send the e-mail and end up
> looking like a dummy, is it possible to change the % to an *? Feel free to
> reply directly to me.
>

Try this site.
http://www.raffiudeenillahideen.org/SQL/SQLByExamples/

--
Peter
Mailto:peternew -at- optonline -dot- net

Adapting old programs to fit new machines
usually means adapting new machines to
behave like old ones.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

*** Deva(tm) Tools for Dreamweaver and Deva(tm) Search ***
Build Contents, Indexes, and Search for Web Sites and Help Systems
Available now at http://www.devahelp.com or info -at- devahelp -dot- com

A landmark hotel, one of America's most beautiful cities, and
three and a half days of immersion in the state of the art:
IPCC 01, Oct. 24-27 in Santa Fe. http://ieeepcs.org/2001/

---
You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit
http://www.raycomm.com/techwhirl/ for more resources and info.


References:
HELP ASAP: SQL wild card question: From: Cook, Jenise

Previous by Author: just when you think you heard it all
Next by Author: Re: Biggest salary cut you've taken?
Previous by Thread: HELP ASAP: SQL wild card question
Next by Thread: RE: HELP ASAP: SQL wild card question


What this post helpful? Share it with friends and colleagues:


Sponsored Ads