Re: get first letter from field

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 news:000901c31279$a0df08e0$7c02a8c0@coconut... > > what can i do when i want to be case sensetive > > > > thanks > > > > "Heilo" <grillen@abendstille.at> wrote in message > > 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/ > >