Re: replacement for Oracle initcap function

2006-02-07 Thread Gleb Paharenko
Hello. It seems that there is no such functions: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html However, it should be possible to do with: http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html http://dev.mysql.com/doc/refman/5.0/en/adding-functions.html Sid Lane wro

replacement for Oracle initcap function

2006-02-06 Thread Sid Lane
I am finishing up on performing an Oraclectomy on a bunch of legacy java code (don't ask why the DBA got stuck w/this - sore subject) and have one outstanding problem to solve: Oracle has a function, initcap(), which capitalizes the 1st character of each word and lowercases the rest. for example,