help with SQL statement

  • Thread starter Thread starter PaulM
  • Start date Start date
P

PaulM

Hi
I would like to do a search on a field called
celebrities in a database using a SQL statement, can
anyone help. Is it possible to have a SQL statement
which will search a field and return a result even if the
celebrities name is spelt wrong, or am I trying to
recreate google
 
Hi Mike
Where do I start? I can program basic SQL. I don't need
it to be as good as google just a bit more advanced than
the wildcard statement.
Best wishes
Paul M
-----Original Message-----
Not without some programming.

--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 Released Special Pricing
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible

"PaulM" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Hi Paul,

Have you tried the "LIKE" statement?

"SELECT * FROM yourtablename WHERE (Name LIKE '::Name::')"

Just a thought

Don
========================
| Hi Mike
| Where do I start? I can program basic SQL. I don't need
| it to be as good as google just a bit more advanced than
| the wildcard statement.
| Best wishes
| Paul M
| >-----Original Message-----
| >Not without some programming.
| >
| >--
| >Mike -- FrontPage MVP '97-'02
| >J-Bots 2004 Released Special Pricing
| >http://www.websunlimited.com
| >FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000
| Compatible
| >
| message | >> Hi
| >> I would like to do a search on a field called
| >> celebrities in a database using a SQL statement, can
| >> anyone help. Is it possible to have a SQL statement
| >> which will search a field and return a result even if
| the
| >> celebrities name is spelt wrong, or am I trying to
| >> recreate google
| >
| >
| >.
| >
 
Back
Top