[dba-SQLServer]Proper case?

Billy Pang tuxedo_man at hotmail.com
Wed Jul 30 11:16:36 CDT 2003


I think Initcap is used with PLSQL/Oracle.


>From: "Nicholson, Karen" <knicholson at gpsx.net>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer]Proper case?
>Date: Wed, 30 Jul 2003 07:41:38 -0500
>
>  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
>

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail



More information about the dba-SQLServer mailing list