Use the application that you are using to save the information into the database to verify that the first letter of each entry is uppercase. I know for a fact that this can be done with perl, VB, c/c++, php, asp, javascript, and java.
I have found that sometimes it is better to let the application do some of the legwork, instead of the db. ----- Original Message ----- From: "Jim Philips" <[EMAIL PROTECTED]> To: "Jari Mäkelä" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 9:08 AM Subject: Re: uppercase for first letter 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 --------------------------------------------------------------------- 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