tricky regrex and case case query

[Mike Blezien]

Hi all,

I think this can be done with a SQL query, but not have much luck getting it right. Was hoping to get some suggestions on the best way to do this.

I need to extract the 'name' column in a mysql database table. split the name so we have a "first" and "last" name value, as the name was original entered into the database as their full name instead of the first and last name. My question is, using SQL, can I split the 'name' column to get the two value, then do an UPPER case on the first character for the first name created from the split of the 'name' columnm value.

I can do this using the Perl programming I am writing, but was pretty sure I do this within the SQL query, but haven't been able to get it to work properly.

thanks for any help,


--
Mike<mickalo>Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(985)902-8484
MSN: [EMAIL PROTECTED]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


---------------------------------------------------------------------
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