Re: help with database

Hello Theo, There really only a couple of options. 1) Depending on the database you are using there may be a 'switch' to allow case-insensitive searches. For example MySql (newest versions) are by default case-insensitive in their searches. Other databases like MsSQl is case-insensitive IF you have the switch on. Look at the docs for your database. Search on case .. 2) Before you submit the data to the server you will have to convert all lowercase to uppercase or visa-versa. This is probably not the best alternative as then you have other formatting problems for output. DSig David Tod Sigafoos Thursday, September 28, 2000, 9:00:24 AM, you wrote: TR> At http://www.richel.org/theodoc/index.php3 I run PHP3 to TR> open my Mysql TR> database with 40.000 records. I am very satisfied with this form, but I TR> wished someone could change the script for me so that the searches aren't TR> case specific anymore. I can't program in PHP myself. Thanks in advance. TR> Theo Richel TR> theo@richel.org -- Best regards, David mailto:dsig@teleport.com