Hello everybody !
I have a problem using the SQL operator "Like" from
a servlet,
If I use for example something like
"SELECT * FROM cds WHERE singer Like ' * Mariah * ' ;
"
I want to see all the
singers which name has the word 'Mariah'
it works well if I execute it inside the Access, but it
doesn't
works when I try to do it from a servlet.
If I use
"SELECT * FROM cds WHERE singer Like
'Mariah';"
I only see the singers which name is exactly 'Mariah'
but
I want to see "Mariah Carey" and "A. Mariah
Smith" and ...
(I'm using Microsoft Access and JDBC-ODBC
Bridge.)
Does
anyone know how can I do it ???
Thanks in advance !
Xavier.
