im using query "SELECT * FROM table WHERE field LIKE '% $variable %' "
with this, i want it should not be case sensitive, and should not distinguish betn ram,Ram,RAM. but its not doing so. i don't want the case sensitive result. what can i do to overcome this ? pls suggest any other possible way. thnx and regds, smita. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php