Advanced Select Query [Re-explained]

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Sorry for the re-post, my original post wasn't very clear. this is
very important. I need a query that can return wildcard matches if
there's no exact match. I'm using IIS 5 with ASP.NET and MS Access.
Bascially what I'm trying to do is to partially match a field. It's
like when you type a mis-spelled word in google it gives you
suggestions to the next possible match.

this is what my db table looks like
ID DESCRIPTION
---- ---------------
1 My * address *
2 My * number *
...
here's my pseudo-query
SELECT DESCRIPTION FROM table1 WHERE ...

if the input is "my email address is (e-mail address removed)"
it would select ID 1

I hope this makes sense
Thanks for helping me
Aaron
 
This question might get a better response in
microsoft.public.sqlserver.programming.

Regards,

Mun
 
Back
Top