Convert String to Sentence Case Script

August 9, 2002


This small function from Subhan Munshi converts a submitted string to sentence case.


CREATE FUNCTION fn_ToSentenceCase (@inputstr as varchar(1000))
RETURNS varchar(1000)
AS
BEGIN
	--Author: Subhan Munshi
	declare @Upper as char(1)
	declare @len as int
	declare @count as int
	declare @flag bit
	declare @resultstr varchar(100)
	
	set @len = len(@inputstr)
	set @count = 2
	set @resultstr = upper(left(@inputstr,1))
	while @count <= @len
	begin	
		select @Upper = substring(@inputstr,@count-1,1)
		if @Upper = ' '
			set @flag = 1
		else
			set @flag = 0
	
		if @flag = 1
			select @resultstr = @resultstr + upper(substring(@inputstr,@count,1))
		else
			select @resultstr = @resultstr + lower(substring(@inputstr,@count,1))
		set @count = @count + 1 
	end 	
	
	RETURN (@resultstr)
END







The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers