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