[dba-SQLServer]Proper case?

I use SQL Analyzer more than I use Access when I pull data out of SQL 
Server.



>From: <paul.hartland at fsmail.net>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: Re: RE: [dba-SQLServer]Proper case?
>Date: Wed, 30 Jul 2003 11:43:01 +0000
>
>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.
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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