RE: Uppercase first letter of each word

2002-04-25 Thread Doug Bishop
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

RE: Table statistics

2002-04-04 Thread Doug Bishop
of code in PERL and don't have any immediate plans to learn PERL. Again I ask forgiveness of the lords and warlocks of the mySQL realm. If a sacrifice is required, please advise as to the form. Doug Bishop -Original Message- From: Georg Richter [mailto:[EMAIL PROTECTED]] Sent: Thur

RE: Table statistics

2002-04-03 Thread Doug Bishop
Try: "; } ?> Doug -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:23 PM To: [EMAIL PROTECTED] Subject: Table statistics Is there a command I can give in the mysql client to find the number of rows in a table or, better still, the numb