[dba-SQLServer]Proper case?

 INITCAP(string) = first letter of each word capitalized, respectively


-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg]
Sent: Tuesday, July 29, 2003 11:06 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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.



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com