[dba-SQLServer]Proper case?

paul.hartland at fsmail.net paul.hartland at fsmail.net
Wed Jul 30 06:43:01 CDT 2003


Why do you need this to be carried out in SQL Server is there a particular reason for this....If I need anything like this I write my own functions in either Access or Visual Basic (if and when I need to)

Paul Hartland


From: "Nicholson, Karen" <knicholson at gpsx.net>
Date: Wed 30/Jul/2003 12:41 GMT
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.




More information about the dba-SQLServer mailing list