Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-07 : 17:06:26
|
john writes "Hi
I'm working on ACCESS databases in ASPs and I would like to create a kind of clever search engine which could find for example the name 'Lüpértz' stored in the table 'Authors' when asked for 'Lup', 'Lüpe', 'Lupért', 'Franz Lüpertz' and so on.
Having read the ACCESS help, I tried to use this kind of query:
SELECT Authors.name FROM Authors
WHERE Authors.name LIKE '%L[uüù]p[eéëè]rtz%'
where '[éeëè]' was supposed to stand for either 'e', 'é', 'ë' or 'è'.
But it just doesn't work with ADODB!
the only thing I could do was:
SELECT Authors.name FROM Authors
WHERE Authors.name LIKE '%L_p_rtz%'
but it gives unwanted answers with a name full of vowels.
What can I do now?
P.S: I hope you will not blame me for my unelegant english, as I'm a french student.
Thanks." |
|
|
|
|
|
wildcards, accentuated text, approximate spelling