[dba-SQLServer]Proper case?

Or:

create  FUNCTION firstLetterUpperCase (@item varchar(100))
RETURNS varchar(100) AS  
BEGIN 

Declare @str varchar(100),
    @idx int,
    @strLength int

set @idx = charindex (' ', @Item, 1)

if (@item is null) or len (@item)  = 0
    return @item


set @strLength = len (@item)

set @str = lower (@Item)
set @str = upper (substring (@str, 1, 1)) + substring (@str, 2, @strLength
-1)

while @idx > 0
begin
    set @str = substring (@str, 1, @idx ) + upper (substring (@str, @idx+1,
1)) +  substring (@str, @idx + 2, @strLength - (@idx + 1)) 
     set @idx = charindex (' ', @item, @idx + 2)
end

return @str

END



-----Original Message-----
From: Billy Pang [mailto:tuxedo_man at hotmail.com]
Sent: Tuesday, July 29, 2003 10:07 PM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer]Proper case?


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."

Thanks in advance,
Billy

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

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