How to do case sensitive replace with wild card matching?

[mos]

Ok, put your thinking caps on because this one bit of a toughie.

I an Update statement that will insert a '/' in front of the *first* 
lowercase letter of a field value.
Example: "ABCDef" becomes "ABCD/ef".

Of course it doesn't always end in "ef" and could be any 2 or 3 group of 
letters like "ABcde" becomes "AB/cde".

Any idea on how to do this? Or should I do it manually?

TIA

Mike



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]