If you can't do it within MySQL (I don't know the answer to that one) you might be able to dump the information to a text file and process it using awk and then reload it. Awk is perfect for this kind of thing. There is a Windows version, if that is your OS.
On Wednesday 24 April 2002 08:49 am, Jari Mäkelä wrote: > sql,query > > > Hi, > > How could I turn the first letter of each entry to Uppercase letter? > > the UCASE turns each and every letter and all I need is the first one to be > changed > > JAri Mäkelä > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
