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.