HELP ASAP: SQL wild card question

["Cook, Jenise" <jenise -dot- cook-crabbe -at- pacificlife -dot- com>]

_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.

Thanks,

Jenise Cook-Crabbe
Senior Technical Writer
Pacific Life Insurance Company
www.PacificLife.com
jcook -at- pacificlife -dot- com


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

*** 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.