Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

SQL Scripts & Samples

Posted Aug 9, 2002

Convert String to Sentence Case Script

By DatabaseJournal.com Staff


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


SQL Scripts & Samples Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
SQL Scripts & Samples Forum
Topic By Replies Updated
sql help!! add 1 August 22nd, 11:58 AM
How To Combine These 2 Queries into 1 Query ? tarek_land 1 June 7th, 08:37 AM
solving query svibuk 1 February 3rd, 06:08 AM
converting from a character string to uniqueidentifier saturnius 4 January 4th, 05:56 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date