[dba-SQLServer]Proper case?

On 30 Jul 2003 at 2:07, Billy Pang wrote:

> Is there a "proper case" function within SQL Server?  I know that there is 
> UPPER and LOWER, but what will help me convert the following:
> 
> "the quick brown fox jumped.  it is over for the lazy dog."
> 
> to
> 
> "The quick brown fox jumped.  It is over for the lazy dog."
> 
That's not "proper case", that's "sentence case"

Proper case would be
"The Quick Brown Fox Jumped.  It Is Over For The Lazy Dog."

But the answer in either case is No, you'd have to roll your own 
function.



-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.