this is for php, if you are not using php then try something similar //use explode to create an array with one word in each item $sql_array = explode(" ", $sql_text)
//loop thro the array while(list($val) = each($sql_array)) { $val = ucfirst ($val); $new_sql_text .= $val ; } hth Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: Doug Bishop [mailto:[EMAIL PROTECTED]] > Sent: 26 April 2002 05:10 > To: [EMAIL PROTECTED] > Subject: RE: Uppercase first letter of each word > > > I have no problem with figuring out how to punctuate a field that > contains a > single word, but how would I code a SQL query to proper-case each > word in a > field when the field contains, for instance, a title? I want to convert, > "HOW NOW BROWN COW" to, "How Now Brown Cow" > > Thanks, > Doug > > > --------------------------------------------------------------------- > 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