Advanced Select Query [Re-explained]

[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 kf***@fsdf.com"
it would select ID 1

I hope this makes sense
Thanks for helping me
Aaron

[Munsifali Rashid]

This question might get a better response in
microsoft.public.sqlserver.programming.

Regards,

Mun

--
Munsifali Rashid
http://www.munsplace.com/


"Aaron" <ku*****@yahoo.com> wrote in message
news:b4**************************@posting.google.c om...

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 kf***@fsdf.com"
it would select ID 1

I hope this makes sense
Thanks for helping me
Aaron