hi , what the meaning of column , is a name of field or reserved word or other? thanks, buttoz "John W. Holmes" <holmes072000@charter.net> wrote in message 000901c31279$a0df08e0$7c02a8c0@coconut">news:000901c31279$a0df08e0$7c02a8c0@coconut... > > 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
