> what can i do when i want to be case sensetive > > thanks > > "Heilo" <grillen@abendstille.at> wrote in message > BADAFFB3.29A2%grillen@abendstille.at">news:BADAFFB3.29A2%grillen@abendstille.at... > hi! > > SELECT `customer` FROM `customerList` WHERE `customer` LIKE "A%" Try: SELECT customer FROM customerList WHERE BINARY LEFT(column,1) = 'a' BINARY will make the comparison case sensitive. Should be able to use the same method with LIKE if you're using that instead of LEFT. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
