One trick is to force the case in your comparison: $ucstringinput = strtoupper($stringinput); $qry = "select * from sometable where upper(address) like '%$ucstringinput%'" Didn't think LIKE was case sensitive, but regardless... forcing upper or lowercase in your comparison doesn't affect output but will make your case sensitivity issue moot. HTH -TG = = = Original message = = = Hi there everyone, I have a little problem, I have a search where people can search the address of a property BUT the search is case sensitive, I don~t WANT it to be. I~m using MySQL and PHP and I generally use something like WHERE address LIKE ~%$stringinput%~ which works with the numbers ONLY, but when I add the address if I don~t put a capital infront of each part of the address it won~t show up. Any ideas how I can make it case INSENSITIVE? (Think that~s the correct phrase). Any help would really be appreciated. Thanks everyone Regards Chris Payne -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/80 - Release Date: 8/23/2005 ___________________________________________________________ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
