首字母小写转大写

[wufaxiangxiang]

比如:
how do you do?
如何转成
How Do You Do?

[zhou968]

--使用程序块：
declare 
@s varchar(50),
@i int,
@j int
select @s = 'thank you for your help',@i = 1,@j = len(@s)
while charindex(' ',' '+@s,@i) >0
begin
 set @i = charindex(' ',' '+@s,@i)+1
 if @i >=@j continue
 set @s = stuff(@s,@i-1,1,upper(substring(@s,@i-1,1)))
end
select @s

--使用函数：
create function F_split(@s nvarchar(1000))
returns nvarchar(1000)
as
begin
declare 
@s2 nvarchar(1000),
@Split nvarchar(100)
select @s=@s+char(32),@s2=''
while charindex(char(32),@s)>0    
select  @Split=left(@s,charindex(char(32),@s)),@s2=@s2+upper(left(@Split,1))+right(@Split,len(@Split)),@s=stuff

(@s,1,charindex(char(32),@s),'')
return @s2
end
go

declare 
@s nvarchar(1000)
set @s='thank you  for your help'
select dbo.F_split(@s)

[水族杰纶]

--使用程序块：
declare
@s varchar(50),
@i int,
@j int
select @s = 'thank you for your help',@i = 1,@j = len(@s)
while charindex(' ',' '+@s,@i) >0
begin
set @i = charindex(' ',' '+@s,@i)+1
if @i >=@j continue
set @s = stuff(@s,@i-1,1,upper(substring(@s,@i-1,1)))
end
select @s
go
--使用函数：
create function F_split(@s nvarchar(1000))
returns nvarchar(1000)
as
begin
declare
@s2 nvarchar(1000),
@Split nvarchar(100)
select @s=@s+char(32),@s2=''
while charindex(char(32),@s)>0
select @Split=left(@s,charindex(char(32),@s)),@s2=@s2+upper(left(@Split,1))+right(@Split,len(@Split)),@s=stuff

(@s,1,charindex(char(32),@s),'')
return @s2
end
go
学习ing

[ying_wzm]

学习

[xiaomeixiang]

declare @str varchar(200)
set @str='how do you do? '

create table #t(id int identity(65,1),Chr char(1))
insert #t(chr)
select top 26 ' ' from syscolumns

set @str=' ' +@str
SELECT @str=replace(@str,' '+char(id),' '+char(id)) FROM #t
set @str=stuff(@str,1,1,'')
select @str

drop table #t

[新鲜鱼排]

十分怀念oracle里面的initcap函数。

[jasonren]

山羊的方法比较好.

declare @str varchar(200)
set @str='how do you do? '

create table #t(id int identity(65,1),Chr char(1))
insert #t(chr)
select top 26 ' ' from syscolumns

set @str=' ' +@str
SELECT @str=replace(@str,' '+char(id),' '+char(id)) FROM #t
set @str=stuff(@str,1,1,'')
select @str

drop table #t

zhou968 的程序块
如果最后一个单词只有1个字符,是无法转为大写的.

[hyde100]

学习，再看

[lff642]

学习，顶。

[zhou968]

不好意思，set @s = stuff(@s,@i-1,1,upper(substring(@s,@i-1,1))) 和if @i >@j continue 对调下

declare 
@s varchar(50), 
@i int, 
@j int 
select @s = 'thank you for your help',@i = 1,@j = len(@s) 
while charindex(' ',' '+@s,@i) >0 
begin 
set @i = charindex(' ',' '+@s,@i)+1 
set @s = stuff(@s,@i-1,1,upper(substring(@s,@i-1,1))) 
if @i >@j continue 
end 
select @s 
go