Hello Everybody !
I'm looking for a caseless select with like ??????
Because like is casesensitiv by default, my application does:
mysearch = upper(what_i_want)
Select * from adresses where upper(name) like '%?mysearch%'
Is it possible to do an caseless search with like ????
If not
Is it possible to create an index for upper(name) ????
If not
How to speed up the select ??? (about 300000 adresses)
Any help welcomed
Best regards
Albert
'''''
'''''''''
(0 0)
+---------oOO-------(_)-------------------+
| Tel: 0541/5841-868 |
| Fax: 0541/5841-869 |
| Mail: mailto:[EMAIL PROTECTED] |
| Internet: http://www.piepenbrock.de |
+-------------------------------oOO-------+
|__|__|
|| ||
ooO Ooo
