Advanced Select Query

[Aaron]

I need a query that can return wildcard matches if there's no exact
match. There's how the process works.

1. Input = "my email address is kf***@fsdf.com"
2. Look for exact match.
3. Look for wildcard match.
4. Found = "my * address *"
5. output = "my * address *"

I hope this makes sense,
Thanks in advance
Aaron

[William Ryan]

Are you trying to do this on the server side or via a DataTable's select ?If
server side, what are you using?
"Aaron" <ku*****@yahoo.com> wrote in message
news:b4**************************@posting.google.c om...

I need a query that can return wildcard matches if there's no exact
match. There's how the process works.

1. Input = "my email address is kf***@fsdf.com"
2. Look for exact match.
3. Look for wildcard match.
4. Found = "my * address *"
5. output = "my * address *"

I hope this makes sense,
Thanks in advance
Aaron

[Aaron S.]

It's server side. I'm using IIS 5 and MS Access.
Bascially where 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

Thanks for helping me
Aaron

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!